Send interactive pivot table

[Mr_Phil]

Is there a way to send the pivot table to another person without the entire workbook?

I have a schedule. There are three row fields that can be expanded or collapsed to provide whatever level of detail you need to see at that moment. I can copy and paste a static picture of it at any level. But, I’d like to bundle it into an email (Outlook 2010 and up) so that you can click the little plusses to your hearts content without the big full spreadsheet.

I like to read and play with excel. So, I don’t mind reading a book or two if that is what it takes.

Thanks for looking.

[humdingaling]

something like this?

https://exceljet.net/tips/how-to-mak...ed-pivot-table

[Mr_Phil]

something like this?

https://exceljet.net/tips/how-to-mak...ed-pivot-table

Y’know that might be the goto backup plan. I’d like to embed the pivot table into the body of the outlook message. I’d like the embedded pivot table to be expandible and collapsable as well. But, so far I’ve done about a hundred internet searches with no real success. Your article taught me some of the background process and if nothing else I can attach a slimmer workbook than the one that is the source for the pivot table.

Thanks. It helps.

[humdingaling]

oh...the actual pivot table in the email body itself rather than an attachment......dont think ive seen that before
ill have a look at it next week when im back in the office however i dont think it can be done or if it can ...its probably something janky

[humdingaling]

had a look, could not find anything out of the box that works like you are mentioning
there maybe something out there that does it ...but its probably proprietary stuff
not sure how many people that would be willing to spend money on developing something just to bypass clicking/opening an attachment

another option maybe a hosted/cloud pivot table on website
though duplicate of data/data integrity/security etc comes into play then..a bit beyond my scope.....just know its out there