Pivot Table Summaries

  • Thread starter Thread starter Erin
  • Start date Start date
E

Erin

I've got two sheets in a workbook. The first sheet
contains detail data. The second sheet contains a pivot
table based on data in the first sheet.
If a user filters the data in the first sheet, I want the
pivot table to represent ONLY the visible rows. But,
the pivot table seems to see even the hidden rows.
So... I thought I would copy the data from the first
sheet, and do a paste special to a hidden sheet and then
base the pivot table off the hidden sheet.

I think this would work, EXCEPT that I am doing the
copy/paste in the activate event of the summary sheet.
Well, the problem is the paste re-fires the activate
event, so I get in a continuous loop.

Am I making this too difficult?
 
Hi
you may use
application.enableevents = false
before you do your processing

and
application.enableevents = True
after your processing
 
Back
Top