Hi all,
I have created a pivot table that is based on a data which was exported to excel.
I'm looking at the summery data in the pivot table and want to drill down to the row data.
The problem is that the result I get don't match my needs in terms of sort, data format and data filtering.
Does anybody know of a way that I can catch the drill down event and run my own macro
many thanks
Eyal
I have created a pivot table that is based on a data which was exported to excel.
I'm looking at the summery data in the pivot table and want to drill down to the row data.
The problem is that the result I get don't match my needs in terms of sort, data format and data filtering.
Does anybody know of a way that I can catch the drill down event and run my own macro
many thanks
Eyal