Links

  • Thread starter Thread starter martinbarnes
  • Start date Start date
M

martinbarnes

I have a workbook with formulas containing links to a separate workbook. I
recently recieved an updated version of the linked workbook with a different
file name. what is the best way to update the linked data in my workbook,
particularly if the external workbook is updated frequently under a different
file name? Any help would me much appreciated...
 
If the original book was data.xls, then rename it to olddate.xls. Rename the
new book data.xls


It is far easier to rename a workbook then to change all the links in the
destination book.
 
martinbarnes said:
I have a workbook with formulas containing links to a separate workbook. I
recently recieved an updated version of the linked workbook with a different
file name. what is the best way to update the linked data in my workbook,
particularly if the external workbook is updated frequently under a different
file name? Any help would me much appreciated...
Click to expand...
Find and Replace should work, but Gary's Student's solution is much
preferred.

Bill
 
Back
Top