martinbarnes wrote:
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...


Find and Replace should work, but Gary's Student's solution is much
preferred.

Bill