Data Link - Excel Keep asking for file to update valves

**Reggie Wells** · 11-14-2017, 11:00 AM

I am using Index-Match function for two separate (reference) files into one worksheets. While one data link works properly, the other continues to ask for selection of file/file location every time I created a new command which references the spreadsheet. Can two files be used in one spreadsheet to gather data from? Any reason why this file keeps asking for file selection on every new command.

Sample formulas:

=INDEX('M:\Echart\[EChart 1053 Trim Code Sheet Rev 19.xls]Trim Codes with MCS'!AS20:AS1070, MATCH($G$1, 'M:\Echart\[EChart 1053 Trim Code Sheet Rev 19.xls]Trim Codes with MCS'!$A20:$A1070,0))

=INDEX('M\Echart\[EChart 1049 Oracle Trim Code Sheet Nextech.xlsx]Trim Code with Temps’!B2:B215, MATCH($G$24, 'M\Echart\[EChart 1049 Oracle Trim Code Sheet Nextech.xlsx]Trim Code with Temps’!$A2:$A215,0))

[The second is the one giving me the grief]

Thanks

**Syrkrasi** · 11-14-2017, 11:15 AM

If this is your formula
=INDEX('M\Echart\[EChart 1049 Oracle Trim Code Sheet Nextech.xlsx]Trim Code with Temps’!B2:B215, MATCH($G$24, 'M\Echart\[EChart 1049 Oracle Trim Code Sheet Nextech.xlsx]Trim Code with Temps’!$A2:$A215,0))

then fix the errors indicated in RED
=INDEX('M:\Echart\[EChart 1049 Oracle Trim Code Sheet Nextech.xlsx]Trim Code with Temps’!B2:B215, MATCH($G$24, 'M:\Echart\[EChart 1049 Oracle Trim Code Sheet Nextech.xlsx]Trim Code with Temps'!$A2:$A215,0))

* Missing colon: M:
* fix apostrophe (a single quote): Trim Code with Temps'!$A2:$A215

**Syrkrasi** · 11-14-2017, 01:44 PM

Glad that I was able to assist you.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, thanks for the rep!