For the last three years or more, I’ve been living with a little annoyance with Microsoft Excel. It’s one of those things that’s just not quite annoying enough to get to the bottom of, and I figured it was some obscure registry setting I’d never find and must be something odd about my laptop setup…
I usually test my formulas in Excel. The syntax is the same; if it works in Excel, it’s going to work in SharePoint. (There may be exceptions to this, but I haven’t run into them.) Simply set up some cells with the values you need and then work out your formula. Once you’ve got it…
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…