Good day to everyone,
I have several computers connecting to a NAS and they works on an excel file stored in a public folder in the NAS.
One of the older computer with excel 2013 can open the file, edit data and save, but the refresh function won't work, it gives the following error
a compatibility check shows that the power query is needed and this is solved by installing a power query add ins from microsoft
https://www.microsoft.com/en-my/download/de...s.aspx?id=39379
However, there is another computer which is using excel 2016, also unable to refresh and display a same error, but the above add ins is not compatible, it said excel 2016 already come with power query. For this case the compatibility check found no issue, do i need to enable something before it can work?
Is there anything i should check? Or any setting in excel 2016 that i should try?
Thanks in advance
Excel can't refresh data, Initialization of the data source failed