Forum Discussion
Permissions required to refresh data in Excel which is connected to a SharePoint list?
I have come across an issue where a user that is only given Full control to a SharePoint list cannot refresh data that has been exported to Excel. They can export the data and the data shows up in Ex...
The solution is that a user must have access to the site to refresh the data.
Even though the user can export to excel and import the data at that point refreshing the data users another method and requires the site access.
Going to have to go and move the list 🙂