Copying Worksheets between WorkBooks
Posted by Stan on October 25, 2001 6:25 AM
When copying the contents of a worksheet from one workbook to another, I notice that a link is established between the two sheets (even though I did not use Paste Link). How can I avoid this?
Cheers
Stan
Posted by Stan on October 25, 2001 6:32 AM
Problem solved
Posted by Stan on October 25, 2001 6:42 AM
Or so I thought...
I noticed in the Edit option that you can Move or Copy a sheet. I thought this was my answer but when I tried either one, there is still a reference to the Workbook that I copied/moved from. This is annoying because everytime I open the workbook I copied/moved to, Excel asks if you want this link established. What I want is a duplicate of the sheet without a reference to the original workbook. How can this be one?
Cheers
Stan
Posted by Stan on October 25, 2001 6:43 AM
Or so I thought...
I noticed in the Edit option that you can Move or Copy a sheet. I thought this was my answer but when I tried either one, there is still a reference to the Workbook that I copied/moved from. This is annoying because everytime I open the workbook I copied/moved to, Excel asks if you want this link established. What I want is a duplicate of the sheet without a reference to the original workbook. How can this be done?
Cheers
Stan
Posted by mseyf on October 25, 2001 7:58 AM
One thing you could check is to see if any range names copied over with the sheet (Insert>Name>Define and check the "Refers to:" for each name listed)
HTH
Mark
Posted by Don C on October 25, 2001 8:22 AM
COPY the range in the original, then in the copy to workbook EDIT/PASTE SPECIAL/Values
This will bring just the values, not the formulas.
You might then hit
EDIT/PASTE SPECIAL/formats to bring all the formatting to the new workbook.
Posted by Stan on October 25, 2001 8:59 AM
The only solution seems to be...
Because the workbooks are duplicates of each other and I also need to maintain the formulas in the worksheets that are being copied,the only solution seems to be using Edit > Replace to remove the workbook name (replace with "")that is referenced in the sheet I am copying to.
