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?
