I am tasked with migrating data from Sharepoint 2003 to Sharepoint 2007. I am trying to export a spreadsheet from Sharepoint 2003 to Excel then use SharePoint 2007 to Import but I keep getting an error that states, "Unexpected error, unable to publish." My spreadsheet is 64 Columns wide and 811 rows long. Can someone please tell me how to fix this or what is wrong?

Hi, Thanks to share your post. For the issue, please make sure that you have activated the Excel service. And please also try to ensure the excel file exported from the SharePoint 2003 could be open correctly. Finally, please follow this article to import the spreadsheet again. Hope this could help you! Leo

Hi, Please make a note of these points before carrying out this activity: 1. Check the columns of source and destination site.They should be in sync. 2. Check if enterprise site features are activated or not. If still you are unable to do so. Then follow these steps: 1. Go to Actions in the destination list. 2. Go to Edit in Spreadsheet option. 3. Copy from source excel and paste here. I hope it will help. Thanks, Rahul Rashu

Hi, Please make a note of these points before carrying out this activity: 1. Check the columns of source and destination site.They should be in sync. 2. Check if enterprise site features are activated or not. If still you are unable to do so. Then follow these steps: 1. Go to Actions in the destination list. 2. Go to Edit in Spreadsheet option. 3. Copy from source excel and paste here. I hope it will help. Thanks, Rahul Rashu