Gordon
Excel takes the Calculation mode each session from the settings on the first
workbook opened in that session.
i.e. If you saved Book1 with calc mode in manual and opened it first, calc
mode would be in Manual.
If you saved Book2 with calc mode in auto and opened it after Book1, Book2
would be in manual mode(Excel ignores the auto calc mode in this case).
If you close Book1 before opening Book2, Book2 will be in auto calc mode.
Confusing enough? <g>
Gord
On Sat, 7 Feb 2004 17:50:10 -0600, "G.G. Biggar, Jr." <(E-Mail Removed)>
wrote:
>Sir Dibben --
>
>I had hunted through the Tool bar, looking for a solution. Obviously, I
>looked in all of the wrong places. When I did a check on the myriad of
>other Excel files stored on my system, the Automatic box was (obviously)
>checked.
>
>I guess I won't attempt to assess how this one got turned off. Many thanks.
>
>Gordon Biggar
>
>
>"Gord Dibben" <gorddibbATshawDOTca> wrote in message
>news:(E-Mail Removed)...
>> Gordon
>>
>> Tools>Options>Calculation
>>
>> Change to "automatic"
>>
>> Gord Dibben Excel MVP
>>
>> On Sat, 7 Feb 2004 11:18:27 -0600, "G.G. Biggar, Jr."
><(E-Mail Removed)>
>> wrote:
>>
>> >I am on a Windows 2000 platform, using Office 2000. Recently, when I
>enter
>> >data in a cell, which is linked to other cells on the spreadsheet, the
>newly
>> >computed values in the other cells do not appear until I hit Save, or
>until
>> >I enter data elsewhere on the spreadsheet. The only software changes to
>my
>> >system have been two security updates from the Windows Update web site.
>> >
>> >Does anyone have any thoughts why the changed values are delayed in
>> >appearing on my screen?
>> >
>> >Thanks in advance.
>> >
>> >Gordon Biggar
>> >Houston, Texas
>> >
>> >
>>
>
|
Similar Threads
