In the dependent workbook use Edit, Links, Change Source.

--
Jim
"KCMaster" wrote in message
...
| Is there a simple way to rename an Excel file that is used as a primary
link
| to all formula references in another Excel File without having to redo all
of
| the formulas?