I have a library in SharePoint Online. When on the library I use the Export to Excel button within the tab.
This downloads the query file which I open, after this I click enable on the security notice to enable content.
This then displays the data from the library. However when I press refresh
I am able to export and refresh other libraries in the same manner on the tenancy. I currently have full control access to the data. When looking at the connection properties they are the same as a user who is currently able to complete the above.
The parent site above the library has recently had a name/url change.