View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jrwrm jrwrm is offline
external usenet poster
 
Posts: 1
Default 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!