Home |
Search |
Today's Posts |
#1
|
|||
|
|||
updating linked cells
I've recently updated to office 2003, and I'm having trouble with
Excel. the problem is with worksheets that do not automatically update the results of new cell entries. For example, If I add a new value in a cell that is in a range that calculates the average of that range, the new value is not automatically included in the calculation, although the formula indicates that it should be. the only fix that I've been able to come up with is to go to every cell and update it manually by double-clicking it. This is extremely irritating! Any suggestions? This was not a problem in Office 97 (?) which the spreadsheet was created. Thanks. |
#3
|
|||
|
|||
that did it. Thanks
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I remove empty chart plots from linked worksheet charts | Charts and Charting in Excel | |||
Update linked cells within a workbook??? | Links and Linking in Excel | |||
Averaging only cells with data | Excel Discussion (Misc queries) | |||
Calculating without including Hidden Cells | Excel Discussion (Misc queries) | |||
Cells losing formatting | Excel Discussion (Misc queries) |