Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i reformat text size in all comment boxs to a default size | Excel Worksheet Functions | |||
Cell size? Or size limit for Text data type? | Excel Discussion (Misc queries) | |||
My tabs' font size is smaller - how do I restore default size? | Excel Discussion (Misc queries) | |||
Can we write VBA code to set all column/row's size back to default size? | Excel Programming | |||
Can we write VBA code to set all column/row's size back to default size? | Excel Programming |