I recently started using MS Excel Pivot tables. Having updated to Office 2007, I was enjoying the greater freedom with conditional formatting. Unfortunately, my client who needed to work with this file is still working in Office 2003. I thought that would not be a big deal as long as I keep all the same rules like only using three conditional formatting colors. Alas, I was wrong. I went into the file that I had saved into xls format and viewed it on a machine running Excel 2003. Not only was the conditional formatting not working, I couldn't get it to work at all. I went in and modified the values in 2003 and it didn't work. I then went in and tried to edit the Pivot Table. The error message is priceless:
This PivotTable was created in a late version of Excel and can't be updated in this version.
To update it, click OK, and then open the workbook in the version of Excel it was originally created in.
Oh well… back to using rocks and sticks.