Monday, August 12, 2013

Cannot import Spreadsheet 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
Post a Comment


snow flakes

blogger widgets Blogspot Tutorial


Related Posts Plugin for WordPress, Blogger...