I've researched for almost an hour now and everything points to the same options.

i've already went to excel options > advanced > and checked the box to ask to update links

i've set the properties to "don't prompt the user" and update the links
i've found in a different post that this should push a prompt to the user to update the links but when the spreadsheets are opened there is no prompt and the links update automatically.

Does anyone have any other options i can try to make this software prompt before updating the links.

Thanks in advance.