Showing posts with label import failed. Show all posts
Showing posts with label import failed. Show all posts

12 August, 2013

import Spreadsheet failed into SharePoint as a list - SharePoint 2010

Problem Description:
I had one user who was not able to Import an excel spreadsheet into SharePoint as a list.

Error Message:
You are not authorized to view this page.  
You might not have permissions to view this directory or page using the credentials you supplied.
HTTP Error 403 - Forbidden

Troubleshooting Done:
-User is a site collection administrator.

-We got the file at our end and checked it worked fine.

-We also checked with the proxy settings but even after changing it to the same as we had it did not work.

-Asked the user to check from a different machine with his login it worked fine

-As it was related to excel tried checking on Microsoft office Diagnostics available in Office 2007.

And to my amaze it worked. We were able to import the spreadsheet without any issues.

Where is Microsoft office Diagnostics?

Start => all programs => Microsoft Office => Microsoft Office tools => Microsoft Office Diagnostics

If at all we have office 2010. We may have to run the Repair available under control panel.

If you have any queries/questions regarding the above mentioned information then please let me know, Thank you.

Product Applies To:
-SharePoint Server 2010

-SharePoint Foundation 2010