MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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.