Power Query Refresh error

[tinferns]

Team - Me and my team is using Office 365. All have updated to the latest version of Excel. The file is saved on Sharepoint Folder. I am the owner of the file, I can run refresh smoothly without any issues. However, if my team runs refresh, they get the below error. Please help... Thanks..

"The queries in this workbook might be incompatible with your current version of excel. These queries were authored with a newer version of Excel or Power Query and might not work in your current version."

 

[GraH]

It's a simple warning message, not an error message. Just confirm and go ahead. What happens then?

 

[tinferns]

Nothing happens. No refresh happens. No changes in data displayed.

 

[GraH]

Just to be sure. After the warning, when you press refresh again. It still does not work? Can they go into the query steps?

 

[tinferns]

Thanks GraH for that question. It solved my issue number one.

I am sure you will have a solution for this as well. When I refresh, it picks up data from the Primary File or Folder and displays it. However, when a remote person does a refresh, all he gets is what I had last refreshed. For them, it does not pick up data from the Primary File or Folder stored on my system. Is there any way out for this?

Please advise.

Thanks.

 

[GraH]

You say "Remote person" and later .... "File/Folder on my system?"
Does the remote person has access to your folder?

If they do the refresh, do they get an error the data can't be refreshed. Do you see a query, in the query pane, with a yellow exclamation point next to it, highlighting there is some kind of trouble?
How do you test new data? Is the file saved before you run the refresh?

You have high hopes, but I'm not clairvoyant.