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