added line won't update accross sheets

[keltawn]

having multiple sheets in a workbook the first four sheets updaye the fifth
sheet. If I add a line the new line will not update to the other sheets. is
there anyway to make this work?

[Jim Rech]

You're saying that you have formulas on the fifth worksheet that refer to
cells on the first four worksheets and that when you make an entry in a cell
on one of the first four sheets to which no formula in the fifth sheet
refers to, that a formula does not magically appear there? If that's what
you want you're going to have to create new formulas yourself on the fifth
sheet, or copy existing formulas down.

--
Jim
"keltawn" <keltawn@discussions.microsoft.com> wrote in message
news:6BC6AFBC-9477-4C92-9B62-BF0BA5F3F005@microsoft.com...
| having multiple sheets in a workbook the first four sheets updaye the
fifth
| sheet. If I add a line the new line will not update to the other sheets.
is
| there anyway to make this work?