Calculation speed issue

[Guest]

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.

 

[Guest]

Take a look at Edit>Links to see if your links are looking at the current,
open workbook or the old closed workbook. The length of calculation time
seems to indicate that Excel is referencing the old, closed workbook.
HTH,

 

[Guest]

Gary:
Thanks for taking the time to reply. I checked links and none are in place.
It appears that the calculation time is the same (~30 times the old speed
regardless of what cell value I change. I understood that excel only
calculates cells that are effected by a change. Manually calculating the
same sheet multiple times without making any change still takes the same long
time.

 

[Mike Middleton]

Steve M -

Here's one of the standard information resources:

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

- Mike
www.mikemiddleton.com

 

[Guest]

Mike:
Many thanks for your reply. I went to the link and in a few minutes learned
quite a bit. Hopefull this knowledge will help me solve my problem.

Thanks again
Steve M