Quote:
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}
__________________
Lï£ê ï§ å Lêmðñ åñÐ Ì Wåñ† M¥ Mðñê¥ ßå¢k

-----------------------------------------------
Q Avatar provided courtesy of manbat's son
AT&T Motorola Q9h WM6 Standard on Vista Ultimate AMD x64
--------------------------------------------------------------
If someone helps you or provides something useful, hit 