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

Top