Links Between Worksheets

K

KCMaster

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?
 
J

Jim Rech

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

--
Jim
| 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?
 
R

RD

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.
 
Top