Forum Discussion
how to remove external links from excel
hello Please help me with following task - I try to remove external links from excel: Data==>Edit Links==>break link It does not work - still I have that external links in the list. Even I c...
I had the same problem. Break Links did nothing. In the end I saved the file in the 97-2003 version (which stripped out the links as they weren't supported) and then converted back.
Odd. Links have been supported by Excel as far back as version 4 (1990), so I am surprised this worked for you.
Beats me. I had a link to another file which 'break links' wouldn't touch so I saved then back again and no more file link :)
- I expect the link was in a feature that is not supported by that Excel version then. Perhaps in formula in a table which isn't visible. What you might try is to add a new empty row to each table in your original workbook and then do a search for .xls.