Max Size???
 

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

Max Size???
 

Strangely enough, I found this earlier tonight:

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

--
Michael Hopwood (Phobos)


"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

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