How can i make formulas automatic (F9)

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

Guest

Hi
every time when i start excel i have to make formulas calculation
automatic, all time it's come Manual I have to press F9.
How can i make it automatic default.

Thanks
 
Excel picks this up from the first workbook you open in that session.

So make sure that the first workbook you open is set for Automatic. Don't
forget to check your personal.xls, too.
 

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

Finding Calculate Hangup 1
Formulas do not update 2
F9 Manual Recalculate only for one workbook 7
Difference between F9 and Shift+F9 7
F9, Shift+F9, Ctrl+Alt+F9 etc 3
Snedkeys "{F9}", true does not work 2
Excel Formula for Eclipsing Circles 0
difference between Alt-Control-Shift-F9 and Ctrl-H Replace = with 2

Back
Top