Monday, July 1, 2013

Cannot import Spreadsheet into sharepoint as a list - Sharepoint 2010/2007

I had one user who was not able to Import an excel spreadheet into Sharepoint as a list .

Was getting an Error -

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 realted 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 .


No comments:

Post a Comment

Users cannot see the checked out files in the folder/ library

I Came across a Issue today wherein the user opened a ticket for the below issue Issue : Users cannot see the checked out files in the fo...