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! |
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 |
All times are GMT +1. The time now is 05:26 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com