Pivot Tables/Excel 2007/.xls file format - Save before you start

re: Pivot Tables/Excel 2007/.xls file format - Save before you start

Ross A — Thu, 19 Nov 2009 16:55:34 GMT

I learned through trial and error that if you've already created a pivot table using 12, once you save the file as Excel 2003, you must delete the original pivot table before you create the new one. It doesn't appear that Excel can run one pivot table on 12 and one on 10 at the same time.

re: Pivot Tables/Excel 2007/.xls file format - Save before you start

Nate Oliver — Mon, 01 Jun 2009 19:37:14 GMT

I don't think that's the case, Steve. I think there's one way, save the file, first. Otherwise, I'm not exactly sure.

If there is another way, perhaps I'll figure it out and post, here.

re: Pivot Tables/Excel 2007/.xls file format - Save before you start

Steve James — Wed, 27 May 2009 21:58:59 GMT

The original blog you referred to says this:

> How do I create a version 10 PivotTable in Excel 12?

> The simplest way to do this is by using compatibility Mode.

This implies there are other ways, which intrigues me. What would they be?