Hi.

I have the most up to date excel, and i have been setting up an excel document on windows on our server.

I use hyperlinks to other excel documents on the server to get the data i need.

Once i click on the mac version and click update, the mac can not recognise the links so i have to reconnect them. However on windows it works automatically.

How can i get my mac to automatically update rather than me having to connect each file to the document each time i open the file?

Thanks.