Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change colour of worksheet tabs in Excel | Excel Discussion (Misc queries) | |||
Change worksheet radian default | Excel Discussion (Misc queries) | |||
Change complete worksheet to degrees | Excel Discussion (Misc queries) | |||
CHANGE WHOLE EXCEL worksheet TO UPPERCASE LETTERS? | Excel Discussion (Misc queries) | |||
how to change data in worksheet in text without confirming each s. | Excel Discussion (Misc queries) |