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.

Order of [Me] and [Today] in filters

We had a strange problem today. A task list view had a filter with due date < [Today] and Assigned to = [Me]. Now when I go to set up an alert for this as shown below, which results in an error. The error is - Exception occurred. (Exception from HRESULT: 0x80020009 (DISP_E_EXCEPTION)) It seemed a pretty strange behavior. I played around a bit and figured out that if you switch the order of the conditions for [Me] and [Today], it will no longer throw the error. Very quirky!