change source worksheet
 

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

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.

--
Jim
"neeraj" wrote in message
...
| 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

But I have seen it ask for a sheet name sometimes when I am changing source

"Jim Rech" wrote:

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.

--
Jim
"neeraj" wrote in message
...
| 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