Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Out of Memory
I am using Excel 2000. Operating system is MS 2000. Ram
= 512. I am running a large Excel file 65,536 rows by 24 columns. The columns may expand somewhat; say 5 extra rows as the Macro runs. The Excel file links to another Excel file to do some vlookups. Some formatting is going on as well as Paste Special Value. I get an out of error message and Excel stops. If I only have 50,000 rows it works fine. I have increased the virtual memory to the maximum, same thing. Any suggestions???? |
#2
|
|||
|
|||
Hi,
There are only 65536 rows in a worksheet. You cannot use all the rows. Split your sheet into sevral other sheets and use another sheet to compile your records. - mark -----Original Message----- I am using Excel 2000. Operating system is MS 2000. Ram = 512. I am running a large Excel file 65,536 rows by 24 columns. The columns may expand somewhat; say 5 extra rows as the Macro runs. The Excel file links to another Excel file to do some vlookups. Some formatting is going on as well as Paste Special Value. I get an out of error message and Excel stops. If I only have 50,000 rows it works fine. I have increased the virtual memory to the maximum, same thing. Any suggestions???? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Not enough memory for large workbooks | Excel Discussion (Misc queries) | |||
Excel Limitations?? | Excel Discussion (Misc queries) | |||
How can I reinstall my microsoft excel? | Excel Discussion (Misc queries) | |||
Visual Basic Code Remains in "memory" | Excel Worksheet Functions |