Sep 20 2018 08:23 AM
Sep 20 2018 08:23 AM
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.
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
Sep 20 2018 08:47 AM
Jan 18 2019 07:48 AM
I am having the exact same issue and can't find the reference. I tried tabing from the bottom right cell in the table - but still no luck. Any other suggestions?
Jan 18 2019 08:08 AM - edited Jan 18 2019 08:08 AM
Try using FindLink by Bill Manville: http://www.manville.org.uk/software/findlink.htm
Mar 04 2019 02:30 AM
I used the break link add-in recommended and whilst it did find links, and I clicked to delete them, I still have a source listed in the Edit Links section.
So I tried the Break Link button again, but still nothing.
Thank in advance
Lori
Mar 04 2019 05:31 AM