copy formula without links

  • Thread starter Thread starter big jim
  • Start date Start date
B

big jim

I have forgotten how to copy and paste a page with formulas from one
workbook to another workbook without having it still linked to the first
workbook. Can someone help?
 
do edit=>Replace

Replace What =
Replace With ZZ=

copy the page

Reverse the replace.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy and Link Issues 2010 1
Excel Protection 2
Copy/Paste 1
Linking to Access data without destroying formulas 16
Copying range of formulas to anotehr workbook 4
copying cells with formulas, numbers, & text 6
How to create absolute link to cell in another workbook (Excel 2003) 1
Formulas do not link to other workbooks 4

Back
Top