***500 points** Excel-Vlookup
Posted on 2007-03-28
We are using excel 2007 (we had the same issues with 2003).
When we move our excel document to a network share, any of the document that have vlookup no longer work or if they do work they are incredibly slow.
When all the files are on a local harddrive the response is very fast..
For example: We have a shreadsheet that the CEO users for pricing.. When he does a global "find/replace" on the spreadsheet with all the files locally, it takes about 5 seconds, (1300 replacments).. When I move that same files (all the files are in one folder) to a network drive the same find/replace takes about 5 minutes if it completes. Sometimes it crashes excel...
Has anyone else experienced this issue ?
Does any-one have an idea why this is occuring ? Does Vlookup not work across a LAN ?
This is a high priority issue as I need to get the file onto a file server but cannot upset our CEO :)
Any help or suggestions are greatly welcomed...