Geeks With Blogs
Josh Tenenbaum Errant ramblings

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.

Posted on Friday, August 10, 2007 5:54 PM | Back to top


Comments on this post: Excel rant… Pivot Tables are not backward compatible

# re: Excel rant… Pivot Tables are not backward compatible
Requesting Gravatar...
same problem, and other ones... Doesn't feel optimal, but I might have to ask IT department to get me back to excel 2003...
Left by Glenn on Feb 29, 2008 8:10 AM

# re: Excel rant… Pivot Tables are not backward compatible
Requesting Gravatar...
Same problem. I DID have to ask for 2003 back. Luckily, it seems I can run both, but am having to use 2003 for any reports that will be shared. This makes so little sense.
Left by Melissa on Sep 04, 2008 6:30 PM

# re: Excel rant… Pivot Tables are not backward compatible
Requesting Gravatar...
Grrrr... Yes, I created some pivots in the old version, validated they worked and simply did some formatting changes, and added a couple of columns in 2007 and now it will not run in 2005 Excel. This is an incredible waste of time.

G

Left by GHP on Jun 18, 2009 5:17 PM

# re: Excel rant… Pivot Tables are not backward compatible
Requesting Gravatar...
Use compatibility mode while creating pivot on 2007, that would work in 2003.

Refer
http://dearmicrosoftofficeteam.blogspot.com/2008/03/excel-pivot-table-compatibility.html
Left by Sandeep Jain on Aug 10, 2010 8:31 AM

Your comment:
 (will show your gravatar)


Copyright © Josh Tenenbaum | Powered by: GeeksWithBlogs.net