[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More


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

Published on
3,491 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

Protecting & Securing Your Critical Data

Considering 93 percent of companies file for bankruptcy within 12 months of a disaster that blocked access to their data for 10 days or more, planning for the worst is just smart business. Learn how Acronis Backup integrates security at every stage

Join & Write a Comment

This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
A query can call a function, and a function can call Excel, even though we are in Access. This is Part 2, and steps you through the VBA that "wraps" Excel functionality so we can use its worksheet functions in Access. The declaration statement de…

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month