A
aputesting
Hi,
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.
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.