Home |
Search |
Today's Posts |
#1
|
|||
|
|||
added line won't update accross sheets
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? |
#2
|
|||
|
|||
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" wrote in message ... | 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to update links between wk sheets | Excel Worksheet Functions | |||
strange horizontal line showing accross several columns | Excel Discussion (Misc queries) | |||
Links pull wrong line when rows are added | Excel Discussion (Misc queries) | |||
How to remove an extra line added by excel when pasting into notep | Excel Discussion (Misc queries) | |||
How do I make a sheet that combines all tabbed sheets & update as. | New Users to Excel |