ted,

If you have more than a set number of formulas (I think it's 65536) then Excel always shows
"Caclulate".

HTH,
Bernie
MS Excel MVP


"ted1973" wrote in message
...
My spreadsheet contains no external links, Calculation is set to Automatic.
I have used F9 on all of the sheets. Any thoughts?