Excel won't calculate

[Joey]

We are in a large business environment and have a complex
Excel spreadsheet. We are using win 2k with office 2k.
The data will not autocalculate and it will also not
calculate when you press F-9. It will calculate though
when you press F-2 and are on that particular cell.

All workbooks are open that are being accessed. This
workbook has macros as well.

This started happening about 3 days ago.

Thank you,
Joey

 

[Ron de Bruin]

You can force it with CONTROL+ALT+F9.

Or maybe this
http://support.microsoft.com/default.aspx?scid=kb;en-us;191661
XL97: Worksheet Not Recalculated with More Than 240 Formulas in Same Row

 

[Charles Williams]

If you are using User-defined VBA functions then look at
http://www.decisionModels.com/calcsecretsj.htm


Charles
______________________
Decision Models
The Excel Calculation Site
www.DecisionModels.com

 

[Cam]

This may be too simple but have you looked in the Tools
menu and checked the options - caluclations. It may have
been reset to manual.