Excell 2000 error

[3Dbesh]

My work involves working on an excell worksheet with about 17000 rows & 20
columns. When i am running the VLOOKUP command linked to another worksheet,
the system is giving an error "Not enough memory", when i am saving the
worksheet. The problem does not occur when i am reducing the number of rows
to about 8000, but reoccurs if the number of rows exceed about 10000. My
system configuration is P4 2.4G with 1Mb cache on a Intel original 915
chipset based motherboard with 512Mb DDR RAM - PC400. I am using Original
licenced copy of Windows XP & Office 2000. I have tried on other versions of
windows but the problem persists. Even increasing the virtual memory to
1024Mb or even 2048Mb does not solve the problem. Somebody please help. I am
stuck!

 

[Tom Wickerath]

I think this KB article might discuss the problem you are experiencing:

XL2000: Error Message: Unable to Save External Link Values
http://support.microsoft.com/?id=214342

You should probably try reposting to a newsgroup for Excel (microsoft.public.excel ?). This
newsgroup is for questions relating to Microsoft Access, the database software.

Tom
_____________________________________


My work involves working on an excell worksheet with about 17000 rows & 20
columns. When i am running the VLOOKUP command linked to another worksheet,
the system is giving an error "Not enough memory", when i am saving the
worksheet. The problem does not occur when i am reducing the number of rows
to about 8000, but reoccurs if the number of rows exceed about 10000. My
system configuration is P4 2.4G with 1Mb cache on a Intel original 915
chipset based motherboard with 512Mb DDR RAM - PC400. I am using Original
licenced copy of Windows XP & Office 2000. I have tried on other versions of
windows but the problem persists. Even increasing the virtual memory to
1024Mb or even 2048Mb does not solve the problem. Somebody please help. I am
stuck!