Forum Discussion
Deleted
Sep 20, 2018Breaking Links and Name Manager
my department has a spreadsheet we all update for inventory. Now that we have all put in our information we now get this pop up that states "we can't update some of the links" every time we open the file. SO ANNOYING. I know i can't set it to never update or prompt but i want to RESOLVE the Issue not put a bandaid on it.
when i open the filewhen i choose edit links
following what I could on some forums I have tried to break the link in edit links but selecting Break link does nothing. I have tried to go through the work book and figure out what cells are using the source. i have even recreated the work sheet and did a copy and past special values & number formatting hoping i would loose the external link. still no luck.
there was another forum that mentioned deleting the entry in name manager but i get no option to delete the object. I just want to remove the reference to the external link or find a way to narrow down what is using that external link exactly. also throughout the workbook the worksheets do have drop down menus