We have a Excel spreadsheet with links to other data sources which works perfectly on all the other computers in the office.
But on my computer when I try to open the spreadsheet
I get "this workbook contains links to other data sources etc etc"
click on UPDATE or DONT UPDATE
If I click on UPDATE I get "this workbook contains one or more links that cannot be updated" with the buttons "Continue" or "Edit Links"
If I choose EDIT LINKS it shows all the links with an error "Source not found"
If I look at the location line it says:
when it should say:
"\\server\COMPANY FOLDER\factory\production stats\2015"
I do not know why the "\COMPANY FOLDER\" is missing from the link.
If I click on "Change Source" and browse to the correct location the error disappears. but as soon as I save and reload the spreadsheet
the same error comes back!!!