View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave O Dave O is offline
external usenet poster
 
Posts: 427
Default Excel formulas not calculating

Hi, bobber5-
Sounds like your files require their calculation trees to be re-built.
You can do this by simultaneously pressing CTRL-ALT-SHIFT-F9. The
computer will pause for longer than the usual recalculation. Save the
file afterwards, and all should be back to normal.

Dave O
Eschew obfuscation