This week, we finally reproduced a problem that had been reported by a remote user: When she tried to export the contents of a list to excel, things would seem to start working, but then Excel would pop up an error: "Cannot get the list schema column property from the SharePoint list". She was running office 2003, windows XP and connecting to MOSS.
I searched the Internets and saw some speculation but nothing 100% definitive. Hence, this post.
The problem: Exporting a view to excel that contains a date (date = the data type of the column).
What worked for us: Convert the date to a "single line of text". Then, convert it back to a date.
That solved it. It was nice to see that the conversion worked, actually. It was quite nervous that converting things this way would fail, but it did not.
This bug has thrown a huge shadow over the date data type in the client’s mind, so we’re going to be seeking out a definitive answer from Microsoft and hopefully I’ll post and update here in the next short period of time with their official answer and hotfix information.
Subscribe to my blog.