E
Excellion - ExcelForums.com
Any help would be appreciated
I have this workbook that reads info in from data files (not exce
workbooks) which is then in turn used in another workbook t
calculate values. The problem is that these files were moved t
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 trie
to refresh data
Before you say go to Edit > Links, that only works to restor
broken links between workbooks I need to know how to restore a lin
between where Excel is referencing the data files fo
import/refreshing. Right now the workbook keeps looking in the ol
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 ar
in D: but the workbook still looks for the data in C:. It wouldn't b
a big deal but in Workbook2 there are several hundred references t
the raw data that all need to be relinked manually if I can't find
way to effect a global relink
Thanks in advance
I have this workbook that reads info in from data files (not exce
workbooks) which is then in turn used in another workbook t
calculate values. The problem is that these files were moved t
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 trie
to refresh data
Before you say go to Edit > Links, that only works to restor
broken links between workbooks I need to know how to restore a lin
between where Excel is referencing the data files fo
import/refreshing. Right now the workbook keeps looking in the ol
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 ar
in D: but the workbook still looks for the data in C:. It wouldn't b
a big deal but in Workbook2 there are several hundred references t
the raw data that all need to be relinked manually if I can't find
way to effect a global relink
Thanks in advance