Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Copy worksheet without absolutle references
How do you copy a workSHEET from one workBOOK to another workBOOK, without
the absolute references to the original workBOOK being contained in the formulas, AND keep the original formatting of the workSHEET. That is, it seems to insert [original_workbookname] in front of my formuals, and thus is creating a link between the two workBOOKs. I dont want a link, I just want to copy the formulas as they are, and the formatting from one workBOOK to another workBOOK. Your assistance is appreciated. Griffo |
#2
|
|||
|
|||
I'd change the formulas to text, copy, then fix the formulas.
Select all the cells (Ctrl-a, twice in xl2003) edit|replace what: = (equal sign) with: $$$$$= (unique string) replace all Copy that sheet full of text strings to the new workbook. Edit|Replace what: $$$$$= with: = in both worksheets. === Alternatively, copy like you did and then edit|links|change source may work nicely for you. GRIFFO wrote: How do you copy a workSHEET from one workBOOK to another workBOOK, without the absolute references to the original workBOOK being contained in the formulas, AND keep the original formatting of the workSHEET. That is, it seems to insert [original_workbookname] in front of my formuals, and thus is creating a link between the two workBOOKs. I dont want a link, I just want to copy the formulas as they are, and the formatting from one workBOOK to another workBOOK. Your assistance is appreciated. Griffo -- Dave Peterson |
#3
|
|||
|
|||
Griffo
Right-click on the sheet tab and "move or copy". Checkmark "create a copy" and pick your other workbook from the "to book" list. No links created and formatting is intact. Gord Dibben Excel MVP On Wed, 18 May 2005 00:18:04 -0700, GRIFFO wrote: How do you copy a workSHEET from one workBOOK to another workBOOK, without the absolute references to the original workBOOK being contained in the formulas, AND keep the original formatting of the workSHEET. That is, it seems to insert [original_workbookname] in front of my formuals, and thus is creating a link between the two workBOOKs. I dont want a link, I just want to copy the formulas as they are, and the formatting from one workBOOK to another workBOOK. Your assistance is appreciated. Griffo |
#4
|
|||
|
|||
This will work only if your formulas do not reference other sheets in the
original workbook. Gord On Wed, 18 May 2005 15:11:32 -0700, Gord Dibben <gorddibbATshawDOTca wrote: Griffo Right-click on the sheet tab and "move or copy". Checkmark "create a copy" and pick your other workbook from the "to book" list. No links created and formatting is intact. Gord Dibben Excel MVP On Wed, 18 May 2005 00:18:04 -0700, GRIFFO wrote: How do you copy a workSHEET from one workBOOK to another workBOOK, without the absolute references to the original workBOOK being contained in the formulas, AND keep the original formatting of the workSHEET. That is, it seems to insert [original_workbookname] in front of my formuals, and thus is creating a link between the two workBOOKs. I dont want a link, I just want to copy the formulas as they are, and the formatting from one workBOOK to another workBOOK. Your assistance is appreciated. Griffo |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Worksheet Tab Name into a cell address | Excel Discussion (Misc queries) | |||
How do I copy a link that is in columns to another worksheet down. | Excel Discussion (Misc queries) | |||
copy link from next worksheet | Excel Worksheet Functions | |||
Is it possible to copy only selected items to another worksheet... | Excel Worksheet Functions | |||
How do I copy specific items to another worksheet? | Excel Worksheet Functions |