I'm not sure where the best place is to post this, so I'm putting it in the general section. We have many, many Excel files that link to other Excel files. All of them are stored on our QNAP NAS. When using Windows versions of Excel there's no problems with them at all. An example of a directory location would be like this:

=INDEX('/QNAP/QNAPNetDrive1/2017 Store Reports/Data/[Week 29.xlsx]WEEK Summary'!AQ$6:AQ$100,MATCH($A$1,'/QNAP/QNAPNetDrive1/2017 Store Reports/Data/[Week 29.xlsx]WEEK Summary'!$B$6:$B$100,0))

When I open it on Excel for Mac it changes the links to this:

=INDEX('/Volumes/QNAPNetDrive1/2017 Store Reports/Data/[Week 29.xlsx]WEEK Summary'!AQ$6:AQ$100,MATCH($A$1,'/Volumes/QNAPNetDrive1/2017 Store Reports/Data/[Week 29.xlsx]WEEK Summary'!$B$6:$B$100,0))

It changes the "QNAP" to "Volumes" and subsequently can't find the file. I'm using Excel for Mac Version 15.36 (170702)

Any idea how to have Excel read it properly? The actual formula in the file is saved correctly. I called QNAP, but they think its a Microsoft issue.