Thread: Recalculation
View Single Post
  #2   Report Post  
Niek Otten
 
Posts: n/a
Default

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