PC - P4, 512 mb ram 120gb hard disk
I've got a spreadsheet with seven workbooks, 75 ish mb., that kept crashing when trying to calculate.
I've cut it into seven seperate sheets as I thought the file might be too big to do all the calculations simultaneously. The files range from 8 to 21mb.
I have a spreadsheet with about 9500 rows and up to 110 columns. Of these about 30 are ranks. The sheet is set to manual calculations. when i try to do a page recalculate is stops responding and i don't get any progress about cell updates.
as you would expect the sheets smaller than 10mb - take over 1 minute to work.
anyone know whats going on?