asked on

Pivot tables - just data for one variable?

hi Folks
If I want to send someone a pivot table and only include their data how do I do that? I can quickly get an individual pivot table using Report Filter Pages but how can I send that to someone so they only get their own data - even if they drilldown...I can copy and paste but that seems to lose the formatting...any suggestions/guidelines? Thanks

ASKER CERTIFIED SOLUTION

regmigrant

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

agwalsh

ASKER

hi Regemigrant,
I had forgotten about that option that you mentioned which I will pass on. I had thought alright though that they would have to delete the extra information which is what I had said to them...I think for the person concerned it was frustration that they had worked all this data and then couldn't share it effectively. It would be nice to offer them the macro option - that would be great :-)

regmigrant

If I can have a look at the data set and an idea on what separates the customers I'll let you know how complex a macro it would be but technically its a new question which might be useful as other experts might have pre-cooked code

agwalsh

ASKER

I checked this out and it turns out that if you turn off the Source Data option, but leave the drilldown turned on. And then copy the sheet to a new book.. It's exactly what I was looking for. Formatting is retained. They just get their own data but they can drill it down. Thanks a million...

agwalsh

ASKER

What would make this excellent would be just the two tweaks I mentioned...turn off the Source Data option, leave the drilldown option on and copy to a new book. But help (as always) much appreciated :-)