Worksheet links

[Bruce the Battler]

I wish to copy a formula to another workbook but need to break the link so
the formula refers to a worksheet by the same name in the new workbook ie: I
wish to paste a worksheet containing formulas into a number of other
workbooks and that new worksheet has look-up formulas that refer to
worksheets of the same name in each workbook.

 

[Frank Kabel]

Hi
one way:
- make a backup of your source file
- in your source sheet replace the equation sign with $$$$ ('Edit -
Replace')
- copy your source sheet to its new location
- in the target location replace '$$$$' with an equation sign '='

--
Regards
Frank Kabel
Frankfurt, Germany

"Bruce the Battler" <Bruce the (e-mail address removed)>
schrieb im Newsbeitrag
news:[email protected]...

 

[Bruce the Battler]

Thanks Frank, but that means I have to edit each and every formula in the
target location. If I have to do that then I can just as easily remove the
reference to the source from the same formula.

 

[Ragdyer]

<"I have to edit each and every formula in the target location">

NO ... you don't!

Frank meant for you to select *all* your formulas at once, or, select the
entire sheet, and *then* follow his suggestion to use <Edit> <Replace>.

 

[Ragdyer]

Another option is to "Edit Links" after you've completed the copying.
<Edit> <Links> <ChangeSource>,
And click on the current WB name in the "ChangeLinks" window.

 

[Bruce the Battler]

Thanks very much - problem solved.
Bruce

Another option is to "Edit Links" after you've completed the copying.
<Edit> <Links> <ChangeSource>,
And click on the current WB name in the "ChangeLinks" window.