Resolution for "Selected worksheet is not correctly formatted. Please try again. "

Nov 3, 2010 at 4:05 PM


First, thanks to ramp for creating this tool, it's quite the timesaver.

I've noticed that when the user selects 'import from spreadsheet' from a list web part, the URL is /_layouts/SpreadSheet/SpreadSheet.aspx?list={ListId} , where {ListId} is supposed to be the guid of the list, but it is not being populated.  This results in the format error after a user uploads the spreadsheet, before the column mapping step.

In order to import successfully, you must select 'import from spreadsheet' from the list page, /Lists/[list name]/AllItems.aspx.  The list guid is then successfully passed as a query string parameter.