"List from Spreadsheet" using SharePoint Designer 2010 throws "An unexpected error has occurred"

Article ID: 2492798 - View products that this article applies to.
Expand all | Collapse all

SUMMARY

Issue Description : If you try to import a spreadsheet from within SharePoint Designer 2010 to create a list in Sharepoint 2010 you get an error

"An unexpected error has occurred."

Steps To Reproduce:
  • Browse to a SharePoint site
  • From the Site Settings menu click on "Edit In SharePoint Designer"
  • Within SharePoint Designer, choose left menu "Lists and Items"
  • From the Ribbon menu click "List from Spreadsheet"
  • SharePoint Designer will launch the SharePoint site within a browser
  • Add a title on the list and choose File then click Import
  • You will get error message "An unexpected error has occurred"


WORKAROUND

The URL when you try to load the page from SharePoint Designer will look something like the following and it will not work:

http://server/_layouts/new.aspx?ListTemplate=SpreadsheetImport

Append to the URL on the page that is being called from Sharepoint Designer with the following and reload the page.

&ListBaseType=0&DisplayName=Spreadsheet+Import

Example:

http://server/_layouts/new.aspx?ListTemplate=SpreadsheetImport&ListBaseType=0&DisplayName=Spreadsheet+Import

Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.

Properties

Article ID: 2492798 - Last Review: January 17, 2011 - Revision: 5.0
APPLIES TO
  • Microsoft SharePoint Designer 2010
  • Microsoft SharePoint Foundation 2010
  • Microsoft SharePoint Server 2010
Keywords: 
KB2492798

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com