Linking to External Data that has been moved

[Excellion]

Any help would be appreciated

I have this workbook that reads info in from data files (not excel workbooks) which is then in turn used in another workbook to calculate values. The problem is that these files were moved to another location and now I either have to manually relink them all, or find a way to change where the excel workbook points when it tries to refresh data.

Before you say go to Edit > Links, that only works to restore broken links between workbooks I need to know how to restore a link between where Excel is referencing the data files for import/refreshing. Right now the workbook keeps looking in the old location.

The structure is like this:

Workbook1 links to Workbook2 links to raw data

Let's say for example, it was in C: but now the data and workbooks are in D: but the workbook still looks for the data in C:. It wouldn't be a big deal but in Workbook2 there are several hundred references to the raw data that all need to be relinked manually if I can't find a way to effect a global relink.

Thanks in advance!

[Excellion]

Anyone know?