Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Breaking Links
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Breaking Links in Excel 2000 | Excel Discussion (Misc queries) | |||
accessing & breaking links | Links and Linking in Excel | |||
accessing & breaking links | Links and Linking in Excel | |||
Still need help breaking links, but am sorry about the graphics | Excel Discussion (Misc queries) | |||
Breaking Links | Excel Discussion (Misc queries) |