How can i make formulas automatic (F9)

T

Tiya

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

New documents automatically have text in superscript 0
Autonumber field in Excel that behaves the same as Access 0
Making "Change Highlighting" feature darker 1
Grouping Names in Mail Merge 0
Copy addition formula of non-consecutive horizontal cells 2
Display weeks from a Milestone 0
Cells not updated automatically 3
Calculate the median value before a specified list 0

Top