SharePoint 7 Import Spreadsheet error
I am tasked with migrating data from Sharepoint 3 to Sharepoint 7. I am trying to export a spreadsheet from Sharepoint 3 to Excel then use SharePoint 7 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?
May 10th, 2011 5:01pm
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
Free Windows Admin Tool Kit Click here and download it now
May 13th, 2011 5:42am
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
May 13th, 2011 10:14am


