So I have many Excel spreadsheets that contain numerous external links that I don't necessarily want to update every time I open the file. For example, somebody might update some data in another file that I'm not ready to pick up yet. All of a sudden, every single file that I open that contains links, automatically updates from the source files. The weird thing is that when my boss opens the same file (stored on a shared drive), it doesn't automatically update. I've tried to find some general setting that is driving this but can't find anything that works across all files at once.
I'm also getting the "We can't update some of the links in your workbook right now. You can continue without updating their values or edit the links you think are wrong" error message with every file that has links. I click continue or just cancel, it updates the links anyway. Again, my boss doesn't get this message opening the same file.
I've tried going into the Trust Centre and External Content settings and clicking "Disable automatic update of external links". Doesn't work.
I've tried going into Advanced Settings/When calculating this workbook and turning off "update links to other documents" and "save external link values" Doesn't work and next time I open file, "update links to other documents" is clicked back on but "save external link values" remains unchecked.
I tried going into Edit Links and changing the startup prompt to "Don't display the alert and don't update automatic links" This one seems to work but I shouldn't have to do this for every single file that I open. I didn't turn it on in individual files so I don't think I'd have to turn it off individually in ~100 different files. And even if I did want to do this, as soon as I open the file to make these setting changes, the file has already updated.
The fact that it's only happening to me kind of points to some sort of general setting problem.
Help...I've run out of ideas and am losing my mind!
I'm also getting the "We can't update some of the links in your workbook right now. You can continue without updating their values or edit the links you think are wrong" error message with every file that has links. I click continue or just cancel, it updates the links anyway. Again, my boss doesn't get this message opening the same file.
I've tried going into the Trust Centre and External Content settings and clicking "Disable automatic update of external links". Doesn't work.
I've tried going into Advanced Settings/When calculating this workbook and turning off "update links to other documents" and "save external link values" Doesn't work and next time I open file, "update links to other documents" is clicked back on but "save external link values" remains unchecked.
I tried going into Edit Links and changing the startup prompt to "Don't display the alert and don't update automatic links" This one seems to work but I shouldn't have to do this for every single file that I open. I didn't turn it on in individual files so I don't think I'd have to turn it off individually in ~100 different files. And even if I did want to do this, as soon as I open the file to make these setting changes, the file has already updated.
The fact that it's only happening to me kind of points to some sort of general setting problem.
Help...I've run out of ideas and am losing my mind!
