Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I stop VLOOKUP from asking what spreadsheet to look in?
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I stop VLOOKUP from asking what spreadsheet to look in?
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-Pro "Dan" wrote: 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I stop VLOOKUP from asking what spreadsheet to look in?
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. "Ron Coderre" wrote: 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-Pro "Dan" wrote: 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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I stop VLOOKUP from asking what spreadsheet to look in?
Please post the formula so we'll know exactly what you're working with.
*********** Regards, Ron XL2002, WinXP-Pro "Dan" wrote: 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. "Ron Coderre" wrote: 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-Pro "Dan" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Tab Stop with a protected Spreadsheet | Excel Worksheet Functions | |||
Spreadsheet Security | Excel Discussion (Misc queries) | |||
Matching and Moving Data From One Spreadsheet to Another? | Excel Discussion (Misc queries) | |||
Matching and Moving Data From One Spreadsheet to Another? | Excel Discussion (Misc queries) | |||
Vlookup & Trim | Excel Discussion (Misc queries) |