Excel 2000 vs. Excel 2002 - Opening Files

[John BK]

I am having troubles with a workbook that I created that is havin
problems opening.

I created it in 2002, and it opens fine in Excel 2002 for other people
However, when I send it to someone who has Excel 2000, it takes over a
hour to open.

Now I also made a very similar report that works just fine whe
trasferred to excel 2000.

Here are a couple of stats on the workbook that is having problems:

1.5mb
500+ externel links
500+ subtotals
200+ simple calculations (a1+b1; a1/b1;etc..)
1 Worksheet in the book.
2 columns with conditional formatting


Thanks,
Joh

 

[Dave Peterson]

Just guesses....

Are the workbooks that are linked on a network drive? Maybe it's the slowness
of the network--not a real problem with excel.

If you ask the xl2k user to open the workbook(s) that "sends" the data first,
then it could be quicker.

Can you send it to another xl2k user--just to see if it's an xl2k problem or
that user's pc problem?

Cleaning the windows temp folder sometimes works wonders.

If none of this helped:

You may want to take a look at these two sites
(Charles Williams and David McRitchie):

http://www.decisionmodels.com
http://www.mvps.org/dmcritchie/excel/slowresp.htm