Export to Spreadsheet error

Have you ever seen the error "Cannot get the list schema column property from the Sharepoint List" when you try to export the list to a spreadsheet? Here are the possible resolutions-

One, Upgrade to office 2007. Office 2007 has a closer integration with MOSS 2007 and this error is fixed.

Two, remove the date fields from your list. The schema property that is having conflicts are the date fields. Once you remove them, you will be able to export the spreadsheet.

Three, use the option edit in datasheet to see the data in datasheet view. Then copy and paste the entire data in a new excel workbook.

And yes, if you intend to use this worksheet offline and for reporting, then it will be wise to unlink the list from the Data > List menu.