Copying Worksheet without links to parent workbook

  • Thread starter Thread starter milojg
  • Start date Start date
M

milojg

I am wanting to copy an existing worksheet from a workbook and an
create a stand allow worksheet, however all the formulas are remai
linked to the parent workbook (each formula adds in the parent fil
name). I wish to have the parent file name removed (links removed) fro
each formula - how do I this
 
If you have Excel 2002 (not sure about 2000), you can use Edit | Links |
Break Link.
 

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

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Worksheet relative reference 3
changing worksheet reference name when copying down cells 5
Copy linked worksheets formula to long 2
How to copy & paste a worksheet but change 1 bit of the formula? 1
Copy worksheet from one workbook to a master workbook 2
Linking a workbook to worksheets 1
Link To File That No Longer Exists 1

Back
Top