Hello,
I am working with a Excel 2016 spreadsheet linked to another spreadsheet but having trouble with the links updating. Out of necessity these two spreadsheets must live in separate locations so when I need to update the link I open both documents and then click update. The problem is every time I do this a message pops up that not all the links could be updated and I have to go in and redirect the link every time.
Is there a fix for this. While it's not a big deal because I know how to do this if anyone else on my team uses the spreadsheet like is supposed to happen they do not.
Any suggestions?
Bookmarks