Breaking the links

  • Thread starter Thread starter Arthur
  • Start date Start date
A

Arthur

I copied a worksheet from one workbook to another using
the "move or copy sheet" feature.

Now when I open the second workbook, I get a message
something like "This workbook is linked to another. Do you
want to update the links?"

I've now got the raw data I need in the second workbook.
Is there some way I can "break the links" so the message
doesn't keep appearing when the workbook is opened?

Art
 
Hi Arthur,
I've now got the raw data I need in the second workbook.
Is there some way I can "break the links" so the message
doesn't keep appearing when the workbook is opened?
Click to expand...

Choose Edit, links, select the link, choose change source and point to
the file the links are in.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com
 
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

Link won't break in Exel. 2
Excel Protection 2
How to create absolue path link to another workbook (Excel 2003) 1
Move/Copy Worksheet with Macros 2
Excel Move or Copy Stopped Working? 0
Link? 1
break link to email workbook 1
break links not working 39

Back
Top