Time to do this: 1 minute
This error popped up when I was attempting to export a SharePoint Online list to Excel. No matter if I opened the file directly from the site or if I downloaded it first and then opened it, the result was the same. I’d get the error message, dismiss it, and the file would open blank.
The issue here ended up being with authentication to the Office application, in this case Excel. To resolve the issue I performed the following simple steps:
Click the “account” link
At the top, click the “sign out” link
Go back to your SharePoint list and click the “Export to Excel” button
When Excel opens, it should prompt you to sign in with an account
Enter your credentials
Basically the equivalent of unplugging Excel and plugging it back in. Once I entered my credentials, the list data loaded and displayed in Excel.