VBA Pivot Table Object Property Not Recognised in Excel 2003?

Hi,

I am designing a report that will export a couple of sheets to a new workbook and break the links. One sheet has a pivot table on it.

I am on Excel 2010 but i know Users are on 2003 so i have been creating this report in compatibility mode.

I have the following line of code that gives the Pivot Table on the newly created workbook it's source data.

It works fine in 2010 but not in 2003 - i get a property not supported error. Anyone know how to rewrite this to work in 2003? Have been googling without much success

Thanks very much in advance,

J

Please Login or Register  to view this content.

=xlPivotTableVersion10

Is this the property that is failing? Could it be as simple as

=xlPivotTableVersion03

??

=xlPivotTableVersion - 1

I managed to get on a user's machine and tried the above but it still failed....

Originally Posted by JosephP

in 2003 and earlier you need

Please Login or Register  to view this content.

instead of .Create

I tried this and removed the Pivot Table version argument - managed to get on user's machine and it still failed with the object property error....

I've been trying to find the correct syntax for this property but can't find it on google - any idea how i alter my code to include it?

Originally Posted by JosephP

I overlooked the ChangePivotCache method call-that doesn't exist in 2003 either. you have to alter the cacheindex property instead to the index of the new pivotcache