Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linked cells don't automatically update in Excel 2003. Why?
I have Excel 2003, and get automatic Office updates. Lately, I've noticed
that some linked cells do not automatically update when I change the value or formula in the original cell. I have to click on the linked cell and hit enter before the cell will update with the changed value. There seems to be no pattern for which linked cells update and which do not (for example, the original cell may have a percentage, a constant value, or a formula). Some of my workbooks have fifty or more worksheets, so this is becoming a real problem. Help! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linked cells don't automatically update in Excel 2003. Why?
Make sure that calculation is set to automatic.
tools|options|calculation tab If that doesn't help, sometimes this helps. Select all the worksheets (rightclick on a worksheet tab and choose "select all sheets" select a single cell on the activesheet edit|replace what: = with: = replace all rightclick on any of the grouped worksheets and choose "ungroup sheets" It's kind of like reentering all the formulas in one giant swoop. And maybe it'll wake up excel's calculation engine. jrwrm wrote: I have Excel 2003, and get automatic Office updates. Lately, I've noticed that some linked cells do not automatically update when I change the value or formula in the original cell. I have to click on the linked cell and hit enter before the cell will update with the changed value. There seems to be no pattern for which linked cells update and which do not (for example, the original cell may have a percentage, a constant value, or a formula). Some of my workbooks have fifty or more worksheets, so this is becoming a real problem. Help! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How do I update data in linked cells without opening source workbo | Excel Worksheet Functions | |||
How Excel 2003 Highlight random cells and running tally appear? | Excel Discussion (Misc queries) | |||
protecting formula cells in excel 2003 | Excel Discussion (Misc queries) | |||
Cells are being selected automatically in Excel | Excel Discussion (Misc queries) |