"Unknown Error" when importing an Excel spreadsheet to SharePoint Online 2016

Published on
3,266 Points
1 Endorsement
Last Modified:
I tried to use the SharePoint app to Import a Spreadsheet and import an Excel sheet into a Team site made in SharePoint 2016.
But that just resulted in getting an error message 'Unknown Error'...

Frustrated by getting a less than helpful "Unknown Error" when I tried to import a Spreadsheet into a Team Site made in SharePoint 2016, I went hunting for a solution.

Trying to Google a solution for hours didn't help, nor did reading several articles on Microsoft's Support website give me any luck.

Until I finally realized that I was logged in with different accounts in Office and SharePoint!

So I finally found the solution to this problem. 

I just logged out from Excel, and then logged back in again using the same admin account that I use in SharePoint, and it worked!

A simple fix, yet effective!

I hope this will also help you if you strike the same issue.

Author:Måns Ekman
1 Comment

Expert Comment

by:Andreas Wennborg
Solved my problem. Thanks!

Featured Post

Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

Join & Write a Comment

In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month