file with subtotals

S

sam

hi Everyone,

My friend has an excel file which uses a lot of subtotal
formulas for a specific column in his file. His issue is that this file
takes a few minutes to open in Excel 2002. But in Excel 2003 it takes hours
together but doesnt open. Any ideas ?

Please Guide....

Thanks

Sampy
 
D

Dave Peterson

Just something to try.

Have the friend open excel with an empty workbook.
tools|Options|calculation tab|check manual

Then try to open the workbook with the subtotals.

If that doesn't help, maybe the registry tweak in this post by Jim Rech would
help:

http://groups.google.com/[email protected]

Change 9.0 to match the version of excel he's using.
(For xl2003, it'll be 11.0)
 
S

sam

Thanks for the prompt response Dave. I will try that and get back with the
results.
Cheers
Sam
 
S

sam

hi Dave,
Thanks a lot to you mate. That worked fine. We changed the calculation mode
to Manual and it worked fine. My friend has promised me a treat... ! :) I
owe that to u......
Cheers
Sampy

sam said:
Thanks for the prompt response Dave. I will try that and get back with the
results.
Cheers
Sam
Click to expand...
 
D

Dave Peterson

Hmmmmm. Treats!
hi Dave,
Thanks a lot to you mate. That worked fine. We changed the calculation mode
to Manual and it worked fine. My friend has promised me a treat... ! :) I
owe that to u......
Cheers
Sampy
Click to expand...
 
Top