How can i make formulas automatic (F9)

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
 
D

Dave Peterson

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

Formulas do not update 2
Help!Excel will not calculate formulas- Not in manual calculation 6
Calculation set to automatic switches 3
Workbook causes calculation errors 2
F9 Manual Recalculate only for one workbook 7
SUM troubleshoot 2
difference between Alt-Control-Shift-F9 and Ctrl-H Replace = with 2
Automatic calculation Option 1

Top