Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insufficient memory error using shared excel spreadsheet
I have created an excel spreadsheet that is shared by
three users. It pulls in some information using dde links and does a bunch of processing with it. Some of the constants and formulas are changed by the users on a daily basis. At least once or twice a day, when one user changes some information and saves it so it will show up in the other two users spreadsheets, an error message will pop up on one or more of the machines saying "Insufficient memory ..., excel is shutting down" Any suggestions? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insufficient memory error using shared excel spreadsheet
One possible solution is to reduce the number of days kept
in the change history. In the Tools menu, select Share WorkBook. Click on the Advanced tab and cut down the number of days in Keep Change History for days to an appropriate minimum (or turn it off with the checkbox below.) Other advanced settings may help as well. I've seen files balloon up surprisingly fast with a Change History being kept (at least in Excel 97.) So check into this possibility. Phil -----Original Message----- I have created an excel spreadsheet that is shared by three users. It pulls in some information using dde links and does a bunch of processing with it. Some of the constants and formulas are changed by the users on a daily basis. At least once or twice a day, when one user changes some information and saves it so it will show up in the other two users spreadsheets, an error message will pop up on one or more of the machines saying "Insufficient memory ..., excel is shutting down" Any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 -insufficient Resources | Excel Discussion (Misc queries) | |||
insufficient memory to create the bitmap | Excel Discussion (Misc queries) | |||
Out of Memory error | Excel Discussion (Misc queries) | |||
insufficient columns in a spreadsheet | Excel Discussion (Misc queries) | |||
Out of memory error. | Excel Programming |