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

Published:
Edited by: Andrew Leniart
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.


1
1,047 Views

Comments (1)

Solved my problem. Thanks!

Have a question about something in this article? You can receive help directly from the article author. Sign up for a free trial to get started.

Get access with a 7-day free trial.
Continue Growing Your Skills and Your Career
  • Interact with leading experts on your specific technology problems.
  • Receive the guidance of experienced professionals.
  • Learn from troubleshooting others have experienced.
  • Gain knowledge from a library of courses, all included.