Recalculation

[Guest]

Using Move or Copy I have copied 6 x worksheets into the same workbook.

Although I have Automatic Calculation set, 'Calculate' is continuously
displayed in the status bar as though Manual Calculation is set.

I have tried recalculating using F9 about 50 consecutive times but Excel is
still asking me to calculate.

Also, when I close and save the workbook, 'Calculate' is still displayed in
the status bar even though no worksheets are open.

I have used Move or Copy to duplicate worksheets on may occasions before but
have never encountered this problem.

 

[Niek Otten]

See

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q243495

or

http://www.decisionmodels.com/calcsecretsf.htm

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[Guest]

Following instructions in the second link I have done the following:

- Checked for circular references: there are none in the worksheet
- Ctrl+Alt+F9 for full calculation: the status bar showed the calculation %
only going to 8% before reverting back to 'Calculate' (it is supposed to
climb to 100% if the limit on dependencies to unique references has been
reached)

Looks like the file may be corrupted.

 

[Guest]

"i want to find out how to set Automatic Calculation as the default mode,
rather than having to press f9. it used to be this way in previous editions
of Excel

 

[Ragdyer]

<Tools> <Options> <Calculation> tab,
And click on "Automatic".

 

[Guest]

i have tried this,but each time i open excel fo rthe first time, i have to
reset the calculation to Automatic. Excel does not seem to 'remember' my
instructions.

R van Setten

 

[Ragdyer]

See if this old thread can shed some light on the subject:

http://tinyurl.com/anahg