Macro to show pivot table details..Any ideas?

**Poison990** · 02-26-2009, 09:56 AM

Hello,

I have a pivot table in a tab called billing.

The size of this pivot table depends on how many different customers are in the data tab.

What I want is a macro that will show the details as if you were to double click on the grandtotal, but the grandtotal in column c is never in the same row and I am having difficulty coming up with a macro to do this.

There are some other functions it is performing as well so I just need to add this to the existing macro code.

Thanks
Greg

**DonkeyOte** · 02-26-2009, 10:06 AM

Greg, without seeing the PT etc it's hard to comment... if we assume

a) Grand Total always appear in Column A
b) Field in question always appears in Column C

Then perhaps along the lines of:

Please Login or Register  to view this content.

**Poison990** · 02-26-2009, 10:18 AM

Hello,

I tried just pasting that macro in and I got the error message. Here is what the PT looks like.

Hopefully this will help

Thanks Again
Greg

**DonkeyOte** · 02-26-2009, 10:20 AM

Per the annotation in the code did you alter the sheet name being referenced to be that containing the Pivot Table ?

Please Login or Register  to view this content.

**Poison990** · 02-26-2009, 12:16 PM

I did change it, now its crashing my excel sheet.

It keeps coming up with the error message, over and over again even after I click OK on it.

Any ideas?

Thanks Greg

Here is the code:

Please Login or Register  to view this content.

**DonkeyOte** · 02-26-2009, 01:08 PM

I'm not quite sure where to begin but first to resolve your issue (I hope) you need to change the below section:

Please Login or Register  to view this content.

To something more along the lines of:

Please Login or Register  to view this content.

As it is you're going into the error handler as part of the routine and thus a perpetual loop... also as above you should be resetting your App settings to TRUE not FALSE ... Events unlike ScreenUpdating will not reset to True by default and is pretty much guaranteed to cause you major headaches.