Re: excel spreadsheets are not auto calculating

  • Thread starter Jan Karel Pieterse
  • Start date
J

Jan Karel Pieterse

Hi,

Excel's calc setting is controlled by the *first* workbook
that excel loads. Check if you have a personal.xls
(Windows, unhide) loaded. If so, unhide it, set it's clacl
mode to automatic, hide it again, close XL and Yes to save
your personal macro workbook.

If no personal.xls, you obviously have a file that has set
calc to manual and you frequently load that file first.

Regards,

Jan Karel Pieterse
Excel TA/MVP
 

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

Excel 2003 automatic calculation all worksheets except one 3
Override Excel's Heroin Addiction to Calculating 4
excel macro buttons created on quick access toolbar wont work 1
Personal.xls does not open automatically (Excel 2002) 1
Re: Excel starts in safe mode 0
Re: Ctrl + F not working? 0
Not Your Average Personal.xls Problem 0
How to tell Excel to recalc, unconditionally, now? 2

Top