collapsing/expanding pivot table fields in excel 2003

Hello,

I have developed a pivot table in excel 2007 along with some code that expands/collapses fields. When I open the file in 2003, and I try to run the code it errors out. Not sure how to make this code compatible for BOTH 2003 and 2007. The code for expanding/collapsing my fields that i have generated and works in 2007 is as follows:

Please Login or Register  to view this content.

Does anyone have any suggestions? Thank you

Hey Richard,

Please see the example workbook I have attached. This is not the target workbook but it is does exactly what I need it to do. Again, I need this to work in both excel 2003 version as well as excel 2007.

Thanks!

Anyone? Need help on this ASAP!

Hey Richard,

I just realized that the data source for the pivot table isn't maintained...Not sure why, but this isn't a problem for my target workbook. So if you don't mind, please change the data source to the entire data set on the data tab (A1:E440). Then Drag the fields on the pivot table field list to the following:

Report Filter:
- League
- Team

Column Labels:
- Date

Row Labels:
- Player Name

Sum of Values:
- Pos

In order to get the Expand/Collapse buttons to work in the workbook, you will need to group the Date columns:
- Everything including January I grouped to be Group 1
- Everyting including February I grouped to be Group 2

Once these are complete, you can use the expand/collapse button. If you have any questions, please let me know! This should only take 1 minute...and i do apologize that the pivot table doesn't maintain the data source. But please keep in mind, that this is not an issue with my target workbook!

Sorry I had a workbook_open procedure that was clearing the data source. Now the workbook is formatted for code testing!

Please see the new attached workbook.

Can anyone help me with this!!!?? I really need to get this compatible with 2003.