Handling Large Files
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...
|