Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Way to prevent VLOOKUP from verifying remote file exists?
Is there a way to stop the VLOOKUP function from accessing a remote file
which is listed as the lookup table? I have a cell like: =VLOOKUP(C3, "C:\users\mike\[lookup.xls]... and I need to change the reference to the external file to a different file (that doesn't yet exist). Excel gets concerned and displays a dialog (which I suppress via .DisplayAlerts = false) but still tries to locate the file (which is time-consuming). I have tried setting calculation mode to manual (Application.Calculation = xlCalculationManual) and disabling remote link updating. Does anyone know how to stop this behaviour? TIA -- Mike Frederick |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Checking to see if a file exists. | Excel Discussion (Misc queries) | |||
Test if file exists | Excel Discussion (Misc queries) | |||
Excel: VLOOKUP returns #N/A for a sorted value that exists?? WHY? | Excel Worksheet Functions | |||
Determine if a File Exists | Excel Discussion (Misc queries) | |||
File Exists | Excel Discussion (Misc queries) |