Showing posts with label spreadsheet. Show all posts
Showing posts with label spreadsheet. Show all posts

17 January, 2012

An unexpected error has occurred

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

"An unexpected error has occurred."

What exactly I am doing:
1.   Browse to a SharePoint site
2.   From the Site Settings menu click on "Edit In SharePoint Designer"
3.   Within SharePoint Designer, choose left menu "Lists and Items"
4.   From the Ribbon menu click "List from Spreadsheet"
5.   SharePoint Designer will launch the SharePoint site within a browser
6.   Add a title on the list and choose File then click Import
7.   You will get error message "An unexpected error has occurred"

After hours of troubleshooting and debugging, I got this issue resolved by using the following workaround.

Workaround:
1.   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

2.   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:

I hope the above mentioned information will help you to resolve your issue. If you have any queries/questions regarding the above mentioned information then please let me know. I would be more than happyJ to help you as well as resolves your issues J J