Breaking Links

  • Thread starter Thread starter potter.justin
  • Start date Start date
P

potter.justin

Hi,

I was wondering if there is a way to break links in Excel such that it
does not retain the data that is currently in that cell. What I am
trying to do is set up a summary sheet that links multiple different
workbooks (around 20 or so), however I want the associated linked data
to become "NA" or someother irrelevant value if I delete 1 of the
workbooks. In otherwords instead of breaking the link and keeping the
old value, I want to be able to break the link and lose all data
associated with it.

Any suggestions?
 
Seems to me that if you cut and paste the data source file, the next time you
open the summary sheet it will tell you that links are gone and give you the
option to edit them.
 

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

break links not working 39
Break a link between workbooks when there is no "break" option 2
break link to email workbook 1
Links not linking 1
Link? 1
fixed links to another workbook 4
Link won't break in Exel. 2
Cells act as if they are linked-link does not display in entry bar 1

Back
Top