“Cannot get the list schema column property from the SharePoint list” Error with Excel 2003

This seems to be a fairly widespread issue with no clear solution.  It occurs when the user chooses the ‘Export to Spreadsheet’ Action and the SharePoint list view has a Date/Time column displayed.  With Excel 2007, the data is exported to Excel just fine, but with Excel 2003, the above error is shown in a…

Encoding Query String Values Between .ASPX Pages

I ran into an instance today where a column’s data contained the ampersand (&) character when I hadn’t expected it to.  Since the ampersand is used to separate Query String name/value pairs in the URL, that ampersand was causing me problems. In general, you should always encode Query String values just in case they might…

Enabling ‘KPI List’ as an Available Custom List Type in SharePoint

The documentation for this process on the Microsoft Web site explains the basic steps for this. To create and publish KPIs in Office SharePoint Server 2007, you must follow four procedures: create a KPI list, add the KPI to the list, add a Web Part (Web Part: A modular unit of information that consists of…