Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Converting Large XML Files into CSV Files for Excel | Excel Discussion (Misc queries) | |||
Help with handling large amounts of data - determine "MIN IF" ? | Excel Worksheet Functions | |||
Modifying large CSV files | Excel Discussion (Misc queries) | |||
Handling large amounts of text in an Excel spreadsheet | Excel Discussion (Misc queries) | |||
Using large excel files | Excel Worksheet Functions |