View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default Excel Formulas stop working

Check the Calculation mode to ensure that it is automatic. From the Tools
menu, choose Options and in that dialog the Calculation tab. Make sure it is
set to Automatic.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)


"kvonwald" wrote in message
...
Hi,
I have several Excel Spreadsheets, that no longer represent the formulas.
When sheet was created, formula''s worked, now when I open the
spreadsheet,
the forumulas ignore new data input and formula results do not change.
Very
odd.

Does anyone know how to fix this problem?

Thanks for your help!