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
|