to disconnect a destination book from a source book

  • Thread starter Thread starter officegirl
  • Start date Start date
O

officegirl

I took some sheets from someone else is workbook, the cells no longer link to
it ( they are hardcoded) yet it is keep asking me if I want to update how
can I stop that?
 
You would be surprised where all links can hide. In addition to fromulas they
can be in named ranges. There is a great utility for finding them by Bill
Manville called FindLink...

http://www.oaltd.co.uk/MVP/
 
Or you could just use Edit, Links
Then there is a button to break links.
No extra software or sites
Excel 2003 this is, thats why I asked which version!!!!
 
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

Excel Move or Copy Stopped Working? 0
Excel Protection 2
linking multiple books (source.xls) to a single book (destination. 4
Copy or Move a spreadsheet 1
Need help with a function 1
links to source 1
Updating Links from Closed Source Workbooks 2
Copy Source Cells to Destination Cells Only when a Change Occurs 2

Back
Top