Excel 2007 pivot table compatibility



Long time reader, first time writer. I migrated to Excel 2007 from 2003.
according to the MS Whitepaper I should be able to retain
xlPivotTableVersion10 by using compatibility mode. this works fine for
limited changes, however, when I add a calculated field, it changes it to
xlPivotTableVersion12 which makes it unusable in 2003 without using
conversion, which takes too long and requires users to update the conversion
tool in 2003 and also requires converting in both directions.

I think the problem may be aggravated by the fact that I have a workbook
that has a lot of pivot tables. the table I am editing is pivottable(2) but
the error cascades to all pivot tables in the workbook.


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question