View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Mike Middleton
 
Posts: n/a
Default Calculation speed issue

Steve M -

Here's one of the standard information resources:

http://www.decisionmodels.com/calcsecrets.htm

- Mike
www.mikemiddleton.com

"Steve M" <Steve wrote in message
...
Excel 2002 SP3

I have several workbooks that have multiple worksheets inside. I recently
copied and pasted several of the sheets from one book to another. All
links
and reference in the worksheets of the new book are self contained as they
were in the oricinal copy. The problem however is that the calculation
speed
in the original is approx 1 second. The calculation speed in the new
worksheet is approximately 45 sec.
Q. Is there a way to find out what is being calculated? The lower left
hand
corner shows the percent of calculation coomplete but does not indicate
what
is being calculated.