Thread: Recalculation
View Single Post
  #1   Report Post  
R Ormerod
 
Posts: n/a
Default 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