copy formulas, paste without links

[jtbrown1955]

How can I copy a sheet with formulas to another workbook WITHOUT pasting the links! This does not come up that often, but when it does, it is a pain. I am working on a project and I want to just copy a sheet with a lot of formulas in it to another workbook and I do not want it linked to the original workbook. For now I have to edit each formula.

 

[QuietRiot]

if you right click on the sheet tab and do a move or copy

then select the workbook, then check create a copy

does that work for you?

 

[daniels012]

Quit Riot,
I was thinking the same thing, but I think the links move with the worksheet. Say he has links to Worksheet 1 and he copies the worksheet 2 to another workbook, I think the links stay with the old workbook.

Michael

 

[jtbrown1955]

Quit Riot,
I was thinking the same thing, but I think the links move with the worksheet. Say he has links to Worksheet 1 and he copies the worksheet 2 to another workbook, I think the links stay with the old workbook.

Michael

Yes, the links will stay. This should not be that hard, It is probably something very easy and I am overlooking it. Although, everyone I have asked does not know how and they have had the same problem.

 

[daniels012]

Is there anyway to SaveAs the workbook renaming it? Then add your other worksheets to it?

As far as I know that is the only thing you can do!!!

Michael

 

[Caliche]

This could work:

- In the original workbook, select cells with formulas (Edit, Goto, Special)replace the "=" of each formula for other character (for example, "#", without the quotes)

- Copy this workbook

- In both workbooks, replace the "#" for "="

HTH

caliche

 

[perksukataus]

If you copy the required sections then go to your destination worksheet/workbook and go edit-paste special. Select values - this will strip out all but values.

 

[jtbrown1955]

If you copy the required sections then go to your destination worksheet/workbook and go edit-paste special. Select values - this will strip out all but values.

I want to keep the formulas, I don't want to keep the links.

 

[jtbrown1955]

This could work:

- In the original workbook, select cells with formulas (Edit, Goto, Special)replace the "=" of each formula for other character (for example, "#", without the quotes)

- Copy this workbook

- In both workbooks, replace the "#" for "="

HTH

caliche

That actually worked!!!!! Thank you very much. You would think Excel would give an option of keeping the links or not. Thank you.