This SharePoint bug occurs randomly when a user attempts to 'Export to Spreadsheet' a list that contains dates. The error returned is: "Cannot get the list schema column property from the SharePoint list".
There is a work-around where the columns containing dates can be converted into strings, but this is not the ideal way as every column would need to be changed, and the average computer user will not understand this method; this method will also add an extra step to their process. Additionally, the problem will keep arising each and every time the user wishes to export that list.
After some research, it was discovered that this is a common SharePoint bug. To fix the problem, it is recommended to update the service pack installation on the SharePoint server. There is a support area here: http://support.microsoft.com/kb/941422
Installing service packs should be completed regularly.
If the date issue continues to be a problem after installing the service updates and restarting the server, simply rename the column holding the date values in SharePoint. (This name can always be changed back to the original name.)
Leave a comment