Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
HELP - Not enough Memory, Out of system resource!
Re-post
I am working with an excel file starting from 10 MB, but when I try to create a table 200 x 10000 and re-calculate all formula, the message about not enough memory and out of system resource is pop up, as I try to save my work and check the computer ram [400 MB available] and HD space over [2GB free space]. When I try to re-open the file, it pops up the message about not enough memory, and close the file immediately without completely finish the opening process. The size of file becomes 270MB size. Now I am not able to re-open this file. Does anyone have any suggestions on how to solve this problem? Thank in advance for any suggestions. Eric |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
HELP - Not enough Memory, Out of system resource!
Depending on what version of XL you have, your system RAM may not mean much:
http://www.decisionmodels.com/memlimitsc.htm Some suggestions I copied out of some of Dave Peterson's old posts: You might try a newer or different version of XL. Some people have had luck using openoffice to recover XL files (I usually see this suggested when people cannot open a file due to too many different formats, but still worth a shot). http://www.openoffice.org, a 60-104 meg download or a CD There are also commercial recovery services. I have not and do not know anyone who has used them, but: http://www.officerecovery.com Other than that, I'm out of suggestions. I've never had to deal w/ this issue myself (and hope that I never will). "Eric" wrote: Re-post I am working with an excel file starting from 10 MB, but when I try to create a table 200 x 10000 and re-calculate all formula, the message about not enough memory and out of system resource is pop up, as I try to save my work and check the computer ram [400 MB available] and HD space over [2GB free space]. When I try to re-open the file, it pops up the message about not enough memory, and close the file immediately without completely finish the opening process. The size of file becomes 270MB size. Now I am not able to re-open this file. Does anyone have any suggestions on how to solve this problem? Thank in advance for any suggestions. Eric |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
HELP - Not enough Memory, Out of system resource!
Thank everyone for suggestions
Don't worry on recovery, I get a backup copy, but I need to create 200 x 10000 cells table. For seeking a solution, does I need to upgrade any hardware for creating a large size of table? or will it be the limitation of Excel 2000 on handling memory? Thank for any suggestions Eric "papou" wrote: Hi Eric In addition to JMB's answer: Try and load your file from another computer. If successfull, check the file format of the Excel file -in File SaveAs, File type info- (this because you're mentionning a huge file size) and if relevant, change to standard Excel file and save your file. HTH Cordially Pascal "Eric" a écrit dans le message de news: ... Re-post I am working with an excel file starting from 10 MB, but when I try to create a table 200 x 10000 and re-calculate all formula, the message about not enough memory and out of system resource is pop up, as I try to save my work and check the computer ram [400 MB available] and HD space over [2GB free space]. When I try to re-open the file, it pops up the message about not enough memory, and close the file immediately without completely finish the opening process. The size of file becomes 270MB size. Now I am not able to re-open this file. Does anyone have any suggestions on how to solve this problem? Thank in advance for any suggestions. Eric |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
HELP - Not enough Memory, Out of system resource!
Eric wrote:
Thank everyone for suggestions Don't worry on recovery, I get a backup copy, but I need to create 200 x 10000 cells table. For seeking a solution, does I need to upgrade any hardware for creating a large size of table? or will it be the limitation of Excel 2000 on handling memory? Thank for any suggestions Eric "papou" wrote: Hi Eric In addition to JMB's answer: Try and load your file from another computer. If successfull, check the file format of the Excel file -in File SaveAs, File type info- (this because you're mentionning a huge file size) and if relevant, change to standard Excel file and save your file. HTH Cordially Pascal "Eric" a écrit dans le message de news: ... Re-post I am working with an excel file starting from 10 MB, but when I try to create a table 200 x 10000 and re-calculate all formula, the message about not enough memory and out of system resource is pop up, as I try to save my work and check the computer ram [400 MB available] and HD space over [2GB free space]. When I try to re-open the file, it pops up the message about not enough memory, and close the file immediately without completely finish the opening process. The size of file becomes 270MB size. Now I am not able to re-open this file. Does anyone have any suggestions on how to solve this problem? Thank in advance for any suggestions. Eric I would heed the suggestion to try a newer version of Excel. Bill |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HELP - Not enough Memory, Out of system resource? | Excel Discussion (Misc queries) | |||
not enough resource to display | Excel Discussion (Misc queries) | |||
Available Resource Error | Excel Discussion (Misc queries) | |||
Help with Resource Schedule | Excel Discussion (Misc queries) | |||
excel causing system to be in low system resource | Excel Discussion (Misc queries) |