Log in

No account? Create an account

Previous Entry | Next Entry


Trying to 'port data from one spreadsheet to another. I have 8000 rows and 124 columns to transfer data from, for a total of 992000 independent lookups. Each time I do more than about a hundred rows or 4-5 columns, it causes the system to crash.

So, I get clever, and I transfer the source data spreadsheet to "sheet 2" of the spreadsheet I'm working from, hoping if I'm not referencing another file, it'll work faster. It's a *little* faster. I notice it's re-checking each lookup as I paste in another 100 rows, so I write over each of the 3000x124 cells with its value (replacing an equation that looks up "425" with just "425.") This will speed things up immensely--except that in doing this, I've erased ALL my lookup equations.

So, I "Ctrl-Z" undo.

System crash--it looks up all the rows, and stalls.

MUCH more carefully, I set all the sheets up for the 'port again, and start doing things 3-4 columns at a time. I've gotten up to row "AG" of "DW" rows--and it's going pretty smoothly. I think scanning a few columns is much easier than scanning a few rows, since I'm using a vertical lookup.

And then...

Autosave kicks in. Crash.

(pounds head against blissfully unaware computer)


( 2 comments — Leave a comment )
Mar. 28th, 2005 03:33 pm (UTC)
Wrr! :/

You might pester your IT folks to make sure your copy of Excel has all the updates and patches installed. It's a long shot but it may have been fixed somewhere along the line.
Apr. 2nd, 2005 09:36 pm (UTC)
Export to CSV format or an XML representation, then reimport.

Also, make sure XL is up to date. There might be a stability patch or hte like.
( 2 comments — Leave a comment )

Latest Month

August 2011
Powered by LiveJournal.com
Designed by Taylor Savvy