P Patrick Simonds May 8, 2005 #1 Is there any way to copy a formula from one workbook to another without bringing over the reference to the originating workbook.
Is there any way to copy a formula from one workbook to another without bringing over the reference to the originating workbook.
D Dave Peterson May 8, 2005 #2 If you're just bringing one formula, you can copy from the formula bar and paste into the formula bar. If you're doing lots then you can change the formulas to text, copy|paste, and then convert those text strings back to formulas (in both workbooks): select the range edit|replace what: = (equal sign) with: $$$$$= (some unique string) replace all copy|paste edit|replace what: $$$$$= with: = replace all (both workbooks) === Another option would be to let the links come across. Then use Edit|Links to change the links to point at the current workbook.
If you're just bringing one formula, you can copy from the formula bar and paste into the formula bar. If you're doing lots then you can change the formulas to text, copy|paste, and then convert those text strings back to formulas (in both workbooks): select the range edit|replace what: = (equal sign) with: $$$$$= (some unique string) replace all copy|paste edit|replace what: $$$$$= with: = replace all (both workbooks) === Another option would be to let the links come across. Then use Edit|Links to change the links to point at the current workbook.
