software

Every time I use VLOOKUP on a certain PC it asks what path to take. The path
is in the VLOOKUP so it shouldn't ask. To select the path in every cell is
cumbersome. My other PC works fine. Is there a setting to make it stop
asking? It is in Excel 2003 on Windows XP for both PC's.

I'm guessing it might be something basic....

Does the formula reference a workbook on a mapped drive, instead of a UNC
referenced drive?

Example:
=VLOOKUP(A1,'F:\[MyFile.xls]Sheet1'!$a$1:$D$100,2,0)

Instead of:
=VLOOKUP(A1,'\\ServerName\[MyFile.xls]Sheet1'!$a$1:$D$100,2,0)

If that's the case, chances are that the other PC User didn't happen to map
the same drive letter to the network as the first PC.

In general, ALWAYS use the UNC version when referencing network drives.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Proquot;Danquot; wrote:

gt; Every time I use VLOOKUP on a certain PC it asks what path to take. The path
gt; is in the VLOOKUP so it shouldn't ask. To select the path in every cell is
gt; cumbersome. My other PC works fine. Is there a setting to make it stop
gt; asking? It is in Excel 2003 on Windows XP for both PC's.

Thanks for the response.
I don't think that is it though. It does reference a spreadsheet on the C:
drive and the path looks correct. It is not on a network. Any other tips
would be appreciated.
Thank you.

quot;Ron Coderrequot; wrote:

gt; I'm guessing it might be something basic....
gt;
gt; Does the formula reference a workbook on a mapped drive, instead of a UNC
gt; referenced drive?
gt;
gt; Example:
gt; =VLOOKUP(A1,'F:\[MyFile.xls]Sheet1'!$a$1:$D$100,2,0)
gt;
gt; Instead of:
gt; =VLOOKUP(A1,'\\ServerName\[MyFile.xls]Sheet1'!$a$1:$D$100,2,0)
gt;
gt; If that's the case, chances are that the other PC User didn't happen to map
gt; the same drive letter to the network as the first PC.
gt;
gt; In general, ALWAYS use the UNC version when referencing network drives.
gt;
gt; Does that help?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP-Pro
gt;
gt;
gt; quot;Danquot; wrote:
gt;
gt; gt; Every time I use VLOOKUP on a certain PC it asks what path to take. The path
gt; gt; is in the VLOOKUP so it shouldn't ask. To select the path in every cell is
gt; gt; cumbersome. My other PC works fine. Is there a setting to make it stop
gt; gt; asking? It is in Excel 2003 on Windows XP for both PC's.

Please post the formula so we'll know exactly what you're working with.

***********
Regards,
Ron

XL2002, WinXP-Proquot;Danquot; wrote:

gt; Thanks for the response.
gt; I don't think that is it though. It does reference a spreadsheet on the C:
gt; drive and the path looks correct. It is not on a network. Any other tips
gt; would be appreciated.
gt; Thank you.
gt;
gt; quot;Ron Coderrequot; wrote:
gt;
gt; gt; I'm guessing it might be something basic....
gt; gt;
gt; gt; Does the formula reference a workbook on a mapped drive, instead of a UNC
gt; gt; referenced drive?
gt; gt;
gt; gt; Example:
gt; gt; =VLOOKUP(A1,'F:\[MyFile.xls]Sheet1'!$a$1:$D$100,2,0)
gt; gt;
gt; gt; Instead of:
gt; gt; =VLOOKUP(A1,'\\ServerName\[MyFile.xls]Sheet1'!$a$1:$D$100,2,0)
gt; gt;
gt; gt; If that's the case, chances are that the other PC User didn't happen to map
gt; gt; the same drive letter to the network as the first PC.
gt; gt;
gt; gt; In general, ALWAYS use the UNC version when referencing network drives.
gt; gt;
gt; gt; Does that help?
gt; gt;
gt; gt; ***********
gt; gt; Regards,
gt; gt; Ron
gt; gt;
gt; gt; XL2002, WinXP-Pro
gt; gt;
gt; gt;
gt; gt; quot;Danquot; wrote:
gt; gt;
gt; gt; gt; Every time I use VLOOKUP on a certain PC it asks what path to take. The path
gt; gt; gt; is in the VLOOKUP so it shouldn't ask. To select the path in every cell is
gt; gt; gt; cumbersome. My other PC works fine. Is there a setting to make it stop
gt; gt; gt; asking? It is in Excel 2003 on Windows XP for both PC's.