Breaking Links potter.justin[ at ]gmail.com 30.09.2006 19:37:42 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?