file with subtotals

[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

 

[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)

 

[sam]

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

 

[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

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

 

[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