Excel 2003 SP2 becomes nonresponsive

[Guest]

I have workbooks with several spreadsheets, about 200mb to 300mb in file
sizes. I can save changes while working with any workbook, and can close the
workbook if the size is under about 200mb. Workbooks above about 200mb
cannot be closed, and Excel becomes unresponsive. What can I do to keep
Excel from becoming non responsive?

 

[Gord Dibben]

See Charles Williams' site for info on Excel's memory usage and ways to reduce.

http://www.decisionmodels.com/memlimitsc.htm


Gord Dibben MS Excel MVP