ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   HELP - Not enough Memory, Out of system resource? (https://www.excelbanter.com/excel-discussion-misc-queries/147973-help-not-enough-memory-out-system-resource.html)

Eric

HELP - Not enough Memory, Out of system resource?
 
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


All times are GMT +1. The time now is 08:30 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com