Re: HELP - Not enough Memory, Out of system resource!

Tech-Archive recommends: Fix windows errors by optimizing your registry

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" <Eric@xxxxxxxxxxxxxxxxxxxxxxxxx> a écrit dans le message de news:
2ADEF4D3-C6CE-4043-9053-00AEB014AA8C@xxxxxxxxxxxxxxxx
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




.

Relevant Pages

  • Re: Multi user capability
    ... Are people going to get the same Excel file?, dump to the same Excel File? ... Processing loaded data in sql tables ... I implemented these three stages by using set of physical temporary sql tables (not the memory ones with # and ##) for data transformations etc. ... I used to delete the data in these temporary tables and reuse for the next client. ...
    (microsoft.public.sqlserver.dts)
  • Efficient parsing of large Excel documents in Ruby
    ... I am currently using the parseexcel gem to parse an Excel file so that I ... It would seem that I have two issues - memory usage and performance. ... I am transferring this data into a SQL Server database, ...
    (comp.lang.ruby)
  • Re: HELP - Not enough Memory, Out of system resource!
    ... For seeking a solution, does I need to upgrade any hardware for creating a large size of table? ... If successfull, check the file format of the Excel file -in File SaveAs, File type info- and if relevant, change to standard Excel file and save your file. ... enough memory and out of system resource is pop up, as I try to save my work ... and check the computer ram and HD space over [2GB free ...
    (microsoft.public.excel.misc)
  • Re: Efficient parsing of large Excel documents in Ruby
    ... usage to the minimal needs by only storing the current row. ... This then required the memory usage ... I am currently using the parseexcel gem to parse an Excel file so that I ...
    (comp.lang.ruby)