Error when exporting Sharepoint list to excel

slohombre 

Is it something like this?
https://techcommunity.microsoft.com/t5/sharepoint/unable-export-to-excel-from-sharepoint-list-using-quot-export-to/m-p/792795#M33160

Possible work around from that link is:
My workaround is to
Go to the Site Assets Library on the same site
Create an Excel file
Data > Get Data
Connect to SharePoint Online list

I took the file, did a query and then saved it as an Excel file.  I saved it to the Site Assets Library and then opened it in Excel (client / desktop) and then did a refresh content or connection and when I updated the List item, say adding a 1 to a name in a row, it refreshed!
NOT a great work around when it should work, however it does if it is for a List item that is available to edit for persons or read only, yet the rest of the site is NOT accessible.