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
>-----Original Message-----
>Some of my spreadsheets which are set to automatically
>calculate, stopped calculating for some reason. But they
>calculate when saved.
>.
>
|
Similar Threads
