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
