The query did not run or the database table could not be opened

[lekkala]

I have this Excel spreadsheet to display live SQL data. It was working fine and then suddenly a few users cant refresh data it gives the following message "The query did not run, or the database table could not be opened" and other users can.

 

[Ranman256]

Validate the connections.
Are these users on other versions than the rest?

 

[lekkala]

How to validate the connections? Can you please explain

Yes some users have a different version of excel