View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mark Mark is offline
external usenet poster
 
Posts: 989
Default Calculate message

I am running an Excel 2003 spreadsheet with 20 tabs, many calculations and
Links to external Query Tables resulting in a file that is 33Mb in size.

Initially Auto calculate was enabled, but resulted in the file struggling to
save and re-load as it was taking a very long time to attempt re-calculate to
95%, then eventually giving up and returning the 'Calculate' message in the
bottom left hand corner of the message bar.

I then disabled Auto calc and the file loaded much quicker, but an F9 recalc
still presented the same result of 95% progress and the 'Calculate' message.

Using some previous advice on here, I then tried the CTRL+ALT+F9, same result.

Using further previous advice on here, I wrote a macro to recalculate each
worksheet individually. This showed that some tabs were taking longer to
calculate than others, as I would expect, but each of them achieved 100%.
However, I am still left with the 'Calculate' message.

Should I believe the 'calculate' message? If so, how do I establish where
the problem is as there are no obvious calculation errors?

Thanks.