0

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.

New contributor
VeryPerfect is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.
0

I found the solution to my own problem - I just hadn't set the credentials correctly to all of the queries.

My final query was made of multiple queries which were combined together, and the credential update had only been applied to the combined query. After manually setting the credentials for each of the other queries for other users in Excel, they were able to update successfully.

New contributor
VeryPerfect is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.

Your Answer

VeryPerfect is a new contributor. Be nice, and check out our Code of Conduct.

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.