External data won't update

Hi

I have a small issue with some external data in my Excel (365 CTR)

I've connected to a .csv file, and a MSSQL DB - and everything works pico bello ... on my computer.

If I share the document on our network drive, the intended user can't update external data, it says that the connections are missing? If i look in Excel, the connections are there - but it seems like it's referring to itself. 

Connection string:

Provider=Microsoft.Mashup.OleDb.1;Data Source=$Workbook$;Location=Tra, døgn;Extended Properties=""

SQL CMD:

SELECT * FROM [Tra, døgn]

However, If I edit the connection I get this PowerQuery editor window where I can see the source:

Server/Database

SQL CMD:

SELECT  
[ProductionDate]
,[ProductionShift]
,[ProductionNet]
FROM [SRODB1].[dbo].[Fix_Print1]
where ProductionDate = CAST(getdate() -1 as date)

And, in the PowerQuery, it looks like it's working.

How/why can't another user update that file when it's saved on a network drive? I've even tried to export the connection properties to the same folder as the document.

Is it because the end user is using an older version of Excel?