PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Crashes Re: excel spreadsheets are not auto calculating

Reply

Re: excel spreadsheets are not auto calculating

 
Thread Tools Rate Thread
Old 04-07-2003, 10:36 AM   #1
Jan Karel Pieterse
Guest
 
Posts: n/a
Default Re: excel spreadsheets are not auto calculating


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.
>.
>

  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off