I have my checkbook from 1998 up in xls. also 2.5mb. I started running into problems with excel when it hit about 2.3mb. It would complain about insufficient memory and other things. I have a highly complex spreadsheet with a dozen tabs and tons of very nasty conditional sums. Here's one of the worst: (with curly braces around it of course)
=IF(L45="","",SUM(IF(JDCCU!$A$3:$A$9926="N",0,IF(IF(JDCCU!$C$3:$C$9926>=$M$3,IF
(JDCCU!$C$3:$C$9926<=$M$4,JDCCU!$B$3:$B$9926=L45,0),0),JDCCU!$E$3:$E$9926,0))))
I had to turn off automatic recalculate because it takes 3-5 sec to calculate the spreadsheet.
The other problem I ran into is autofilter stopped working at a certain point. Had to turn off autofilter for the columns that didn't need it, which appeared to help. also I have a note here:
control g
JDCCU!_filterdatabase
apparently that clears/resets something in the auto filter database for the spreadsheet. (JDCCU)
I suppose at some point it's going to just fall apart though. I tried opening it no a newer version of excel and it didn't help.
Last edited by dkmarsh; 09/08/09 11:32 PM. Reason: inserted hard return to avoid stretched browser window
