Links Between Worksheets
 

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?

Links Between Worksheets
 

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?

Links Between Worksheets
 

Is there a way to do this on multiple woorkbooks at once?

We have about 50 that are linked to another we want to move.

"Jim Rech" wrote:

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?