copy formulas, paste without links

jtbrown1955

New Member
Joined
Jan 12, 2005
Messages
40
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.
 

Some videos you may like

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

QuietRiot

Well-known Member
Joined
May 18, 2007
Messages
1,077
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

Well-known Member
Joined
Jan 13, 2005
Messages
5,219
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

New Member
Joined
Jan 12, 2005
Messages
40
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

Well-known Member
Joined
Jan 13, 2005
Messages
5,219

ADVERTISEMENT

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

Active Member
Joined
Mar 26, 2002
Messages
339
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

Board Regular
Joined
Aug 29, 2007
Messages
78

ADVERTISEMENT

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

New Member
Joined
Jan 12, 2005
Messages
40
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

New Member
Joined
Jan 12, 2005
Messages
40
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,464
Messages
5,596,288
Members
414,052
Latest member
Dual Showman

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top