Monday, August 12, 2013
Cannot import Spreadsheet into SharePoint as a list - SharePoint 2010
I had one user who was not able to Import an excel spreadsheet into SharePoint as a list.
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
-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