Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Copying a formula to new workbook
Is there any way to copy a formula from one workbook to another without
bringing over the reference to the originating workbook. |
#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. Patrick Simonds wrote: Is there any way to copy a formula from one workbook to another without bringing over the reference to the originating workbook. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying charts from workbook to workbook | Charts and Charting in Excel | |||
Trouble copying and pasting a formula | Excel Discussion (Misc queries) | |||
copying data from one workbook to another | Excel Discussion (Misc queries) | |||
Copying an array formula... | Excel Worksheet Functions | |||
Copying formula to different cells | Excel Worksheet Functions |