Archive of Mr Excel Message Board

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

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

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

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.

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.