Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excell 2000
Working in large spreadsheets after saving a few times she gets the memory
error. She will need to reboot before she can re-open the sheets. If she tries to open them before rebooting and opening any sheet, they will only open in Read Only mode. A reboot will stop the errors for only a little while. She works extensively in excel. P4 2.4 GHz 512 MB ram 40 GB HD Is this a common issue with Excel and is there a fix or is the person stuck with getting memory errors aftyer working in the sheet and doing mutiple saves. |
#2
|
|||
|
|||
Sounds to me like the file isn't allowing Excel to close properly (still in
use after Excel is closed). Try troubleshooting the workbook: http://www.officearticles.com/excel/...soft_excel.htm ************ Anne Troy www.OfficeArticles.com "holy dog" wrote in message ... Working in large spreadsheets after saving a few times she gets the memory error. She will need to reboot before she can re-open the sheets. If she tries to open them before rebooting and opening any sheet, they will only open in Read Only mode. A reboot will stop the errors for only a little while. She works extensively in excel. P4 2.4 GHz 512 MB ram 40 GB HD Is this a common issue with Excel and is there a fix or is the person stuck with getting memory errors aftyer working in the sheet and doing mutiple saves. |
#3
|
|||
|
|||
How big is the spreadsheet?
How complex? Many charts? What kind of formulas? Is there any vba code? Are there links to other technologies? What version of Excel and windows? Is it only 1 workbook that causes the problem? Is Outlook open? Many things can cause this sort of memory leak, the workbook could be corrupt, could be just too complicated, could be a vba problem, etc. You should pretty much always reboot a machine after having a problem with Excel as it very rarely clears up after itself properly. cheers Simon "holy dog" wrote in message ... Working in large spreadsheets after saving a few times she gets the memory error. She will need to reboot before she can re-open the sheets. If she tries to open them before rebooting and opening any sheet, they will only open in Read Only mode. A reboot will stop the errors for only a little while. She works extensively in excel. P4 2.4 GHz 512 MB ram 40 GB HD Is this a common issue with Excel and is there a fix or is the person stuck with getting memory errors aftyer working in the sheet and doing mutiple saves. |
#4
|
|||
|
|||
This worked thanks.
"Anne Troy" wrote: Sounds to me like the file isn't allowing Excel to close properly (still in use after Excel is closed). Try troubleshooting the workbook: http://www.officearticles.com/excel/...soft_excel.htm ************ Anne Troy www.OfficeArticles.com "holy dog" wrote in message ... Working in large spreadsheets after saving a few times she gets the memory error. She will need to reboot before she can re-open the sheets. If she tries to open them before rebooting and opening any sheet, they will only open in Read Only mode. A reboot will stop the errors for only a little while. She works extensively in excel. P4 2.4 GHz 512 MB ram 40 GB HD Is this a common issue with Excel and is there a fix or is the person stuck with getting memory errors aftyer working in the sheet and doing mutiple saves. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
unable to drag scrollbar in excell 2000 | Excel Discussion (Misc queries) | |||
excell 2000 | Excel Worksheet Functions | |||
Excell 2000 worksheet | Excel Worksheet Functions | |||
Need Your Help on Excell 2000 | Excel Discussion (Misc queries) | |||
need to update excell from office 2000 | Setting up and Configuration of Excel |