| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
External References not working right.
I am using a function to do a lookup on external shared spreadsheet. The
formula goes like this: VLOOKUP(D$2,[Joblist.xls]Sheet1!$A$2:[Joblist.xls]Sheet1!$B$301,2,FALSE) This works great. However, on another machine, Excel replaces [Joblist.xls]Sheet1 with 'T:\office\[Joblist.xls]Sheet1'. Why is this being replaced, and how do I get rid of the compete path? Is there an option setting that is causing this? Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| External data Macro Problem Excel 97 | Excel Discussion (Misc queries) | |||
| How can I check if data in external data range is changed after re | Excel Discussion (Misc queries) | |||
| Changing cell references | Excel Discussion (Misc queries) | |||
| Save External Link Values | Excel Discussion (Misc queries) | |||
| Relative paths to external data? | Excel Discussion (Misc queries) | |||
Threaded Mode
