Welcome Guest ( Log In | Register )

Outline · [ Standard ] · Linear+

> Excel can't refresh data, Initialization of the data source failed

views
     
TSpandah
post Aug 5 2022, 01:14 PM, updated 2w ago

On my way
****
Senior Member
611 posts

Joined: Jul 2011

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

Attached Image

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 notworthy.gif

 

Change to:
| Lo-Fi Version
0.0179sec    0.64    6 queries    GZIP Disabled
Time is now: 17th August 2022 - 11:32 PM