change source worksheet

N

neeraj

In Edit Links, there is an option to change source but one can only change
the workbook not a worksheet within a file. Is it possible?Actually, I was
using this feature to update my formulae
 
J

Jim Rech

Update Links cannot be used to change sheet references or cell references.
It's possible that there could be thousands of formulas with references to
any number of sheets or cells, so the Update Links dialog is not a viable
way to do it.

I think your best course is to be a Find and Replace in the dependent
workbook once it is open.
 
Top