Probably not. Try breaking up the lookup range, if possible. I did this sort
of thing recently for a school system. If all else fails, you may send to me
with a complete explanation.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"RJB" wrote in message
...
I have a file with a data dump.

It has seven worksheets, each about 30 columns by 21,000 rows. Most of the
info is text, although I have about three columns with Vlookups, and four
others with some basic multiplication formulas.

As you may have guessed, it's about 100MB and realllllyyyy
sssssllllloooowwww - to load, to save, to think.

I've stripped out as many formulas as I can.

The only thing I can think of is to break it into seven individual files,
all referencing the same lookup file. And then have a separate summary
file?
Will that speed things up any?

Thanks...