Recalculation
 

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.

--
R Ormerod

See

http://support.microsoft.com/default...;en-us;Q243495

or

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

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"R Ormerod" wrote in message
...
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.

--
R Ormerod

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.

"Niek Otten" wrote:

See

http://support.microsoft.com/default...;en-us;Q243495

or

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

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"R Ormerod" wrote in message
...
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.

--
R Ormerod

Recalculation
 

"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

Recalculation
 

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

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"r van setten" <r van wrote in message
...


"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

Recalculation
 

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" wrote:

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

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"r van setten" <r van wrote in message
...


"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