Tuesday, June 30, 2009

Getting excel into a sharepoint list

Symptom:

When you try to import an Excel spreadsheet into a Sharepoint list using the "Import Spreadsheet" option, the following message appears.

The website declined to show this webpage HTTP 403

Most likely causes:

This website requires you to log in.

What you can try:

Go back to the previous page.

More information

This error (HTTP 403 Forbidden) means that Internet Explorer was able to connect to the website, but it does not have permission to view the webpage.

For more information about HTTP errors, see Help.

Cause and Resolution:

Some have suggested reinstalling Office components on the server or formatting your spreadsheet in table format. Dunno, haven't tried.

Workaround:

Push from Excel as follows:
  1. Data: List: Create List
  2. Choose your list range and click OK
  3. Data: List: Publish List
  4. Enter url and name, and click Finish. All done!

1 comment:

Anonymous said...

Thanks, that worked for me after I was blocked by the 403 error: I created a range of data from a table in Excel 2007 and exported it as a list to my local SharePoint site. It created an Access Web Datasheet type of list, apparently.