Have any of you guys had this damn message!!!
I have come across it recently when working with a large file.
According to Micorsoft this is the cache memory of Excel being exceeded (64MB)
Is there any smart away around this?
To explain how I am trying to get around it at the moment:
I have one file that links to multiple file across the network, each file contains about 5000 entries. I have set up a link in the first range of cells and then written a macro that autofills the data down 5000 rows, however I recieve the 'Not enought Memory' message. So I tried to break up the autofill macros to copy down 250 rows at a time and still I recieve the message.
Is there any other way to achieve what I want (to have the file link to everything)?
Any assistance would be greatly appreciated