need help with RAM/excel vlookup files

[temchris]

I am trying to load a 5MB excel file with vlookup. I dont have enough memory to execute the file. Any suggestions?

[Guardian]

Originally Posted by temchris

I am trying to load a 5MB excel file with vlookup. I dont have enough memory to execute the file. Any suggestions?

I don't know if this will help your particular situation but if you are able to do a registry hack and know how, try this patch to increase your file system's cache and it should help:

Change FileSystem Cache
-----------------------
[ HKEY_LOCAL_MACHINE\System\StorageManager\FATFS ]

Name: EnableCache
DWord: 0 {Default:1}

Name: CacheSize
DWord: 4096 {Default:0}