Re: excel spreadsheets are not auto calculating

  • Thread starter Thread starter Jan Karel Pieterse
  • Start date 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
 
Back
Top