Thread: Max Size???
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default Max Size???

Not really, it all depends on the workbook itself and the computer

Rob Bovey has a utility called code cleaner

http://www.appspro.com/utilities/Cleaner.asp

also for speed in general see
Charles Williams site

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


--

Regards,

Peo Sjoblom

"Jase" wrote in message
...
Hi All

I am just wondering is there a critical size at which
workbooks either stop working or go to a speed that is
unusable? As I have a workbook that has just reached 12
megs mainly from the macros but there is a fair few sheets
in there as well and over the past 2 days the performance
of the workbook has dropped off quite substancially. This
happend when it went from around 11 meg to 12 meg.

Is there a way I can allocate more memory to it or
something of the like?

Thanks heaps
Jase