static formulas - HELP

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

All of sudden formulas in ALL my files do not calculate when I change a
number????????? Ideas (solutions) please.
 
One likely cause is the calc mode's set to manual.
Click Tools > Options > Calculation tab. Ensure auto is checked > OK.
 
(any idea why would it randomly switch to manual?)

Excel sets the session's calc mode based on the mode of the 1st workbook
that's opened. If the 1st book's saved mode happen to be manual, then it's
manual mode. And any subsequent book(s) that's opened within the same Excel
session (irrespective of their earlier saved calc modes) will "take-on" this
manual mode, and if saved thereafter would be saved on manual mode.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formulas do not update 2
Scrabble Value calculation for Welsh words 0
Help!Excel will not calculate formulas- Not in manual calculation 6
My formulas in excel are suddenly not working. Help! 7
Excel help INDEX MATCH w/ division and subtraction 0
Excel Drag autofill only part of formula 3
Time Sum in Excel 1
Sum formulas 3

Back
Top