copied formula is linked to original workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I copy a formula from one workbook to annother without the formula referencing the original file?
 
Hi
one way:
- select the cell
- click F2
- highlight the formula in the formula bar and hit CTRL+C
- paste the formula text
 
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

How can I adress diferent Sheets in same Book according to a cellv 2
Excel not copying formula reference to original workbook 7
how to copy 3 spreadsheets and get the formulas to work 1
Worksheet relative reference 3
Copying cell with input range to different worksheet 4
Worksheet formula incorrect after copying to another worksheet 2
Copying Excel formulas from one Workbook to another 3
Continue Excel to New Uear 9

Back
Top