PowerQuery in Excel 'master' spreadsheet on SharePoint can only be refreshed by one user and gives authentication errors for others

by VeryPerfect   Last Updated September 11, 2019 17:01 PM

I created a group of SharePoint libraries on an intranet that each contain an identically formatted spreadsheet, and another library that contains a “Master” spreadsheet that fills a table from the data entered into each of the other libraries' spreadsheets.

The Master spreadsheet works and can be updated from my account and can be accessed by other users, but when other users try to refresh the data, they are given an authentication error.

All three other users that were unable to refresh the data have access to all the spreadsheets and can open them either in SharePoint, or by navigating to the SharePoint site's folder, and I verified that the 'credentials' settings were the same across all four users.

Related Questions

Updated July 05, 2019 13:01 PM

Updated December 19, 2017 09:01 AM

Updated December 20, 2018 13:01 PM

Updated November 14, 2018 15:01 PM

Updated September 07, 2018 12:01 PM