We have created a DataView WebPart on a list in Sharepoint 2007 using SharePoint Designer with the Sharepoint List Toolbar (so we have the Actions button, including Export to Spreadsheet). When we try to Export to a Spreadsheet (Excel 2003) it fails.
We've tried a couple of different scenarios, we get a different error for each.
If we just create the DataView onto a new aspx page then open the page in IE and try to export the data we get an error box that states and unexpected error has occurred and the data could not be saved. No spreadsheet is created.
If we create a public view page in Sharepoint then open the resulting .aspx in Sharepoint Designer, remove the automagically created view and replace with a DataView Webpart, then save and reopen the page in IE, attempting the export results in a spreadsheet
being created but only the ID numbers exported. We then get a message box saying that some hidden or read only fields need data but do not have a default value.
As the original list is quite complex and has a variety of different data types we created a much simpler list on a separate subsite and repeated these scenarios, with exactly the same outcomes.
We are using Sharepoint 2007 (WSS 3.0) via Internet Explorer 6.0 on Windows XP SP2 to export the data into Excel 2003 SP3. This has been replicated on three dif
View Complete Post