Replace all formulas in one worksheet to link to different worksh

  • Thread starter Relacing all formulas
  • Start date
R

Relacing all formulas

I want all formulas (in sheet 1 of Workbook 2006) that link to workbook #1 to
now link to same cells in workbook #2. Any suggestions on how to make that
happen without individually changing each cell?
 
S

SimonCC

From the menu go to Edit ---> Links...
In the Edit Links pop up box, click Change Source... button and select
another file.

-Simon
 
D

Dave Peterson

Edit|replace|replace all?
I want all formulas (in sheet 1 of Workbook 2006) that link to workbook #1 to
now link to same cells in workbook #2. Any suggestions on how to make that
happen without individually changing each cell?
Click to expand...
 
Top