I have several spreadsheets (Excel 2003) that even simiple formulas have stopped calculating. is it possible I inadvertantly shut off a global formula setting? any ideas, never had this happen before
I have several spreadsheets (Excel 2003) that even simiple formulas have stopped calculating. is it possible I inadvertantly shut off a global formula setting? any ideas, never had this happen before
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
I guess that the calculation method is set to manual (F9). Change that to automatically (Tools meny - Calculation).
This can happen if your first opened a workbook has setting for manual calculation. That overides the settings for next workbook opened even if your calculation setting is automatically.
that was it formulas>calculation options>manual changed to automatic problem fixed
thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks