Pivot Table Drop Down ActiveX

Question

Hi All,

could you please help, whether Pivot Table drop down function can be used programatically?

I mean, I have for example 3 items from a hierarchy in a cell, MemberA, MemberB, MemberC, and if I run a code, Pivot Table drop down appears and helps in showing selection.

Thanks

Answer 1

Hi Stoneclub,

Currently, it seems that there is no API for PowerPivot, I would recommend you to submit a feedback to Microsoft Connect at this link at this linkhttps://connect.microsoft.com/SQLServer/Feedback

---

Challen Fu

TechNet Community Support

Answer 2

Hi Challen,

I used the above link and got the following answer:

Hello,

This issue is not a bug, please use the MSDN forums to get questions answered : http://social.msdn.microsoft.com/Forums/en-US/exceldev/threads 

I will close this bug as won't fix since there is no item to fix on our side. There are many excel OM functions available.

Please help how I can proceed with the next step, thanks

Answer 3

stoneclub, can you provide a link to the Connect item you reported, just so those interested in this issue in the future can find it?

Regarding the functionality you're looking for, have you tried the Filter List feature of OLAP PivotTable Extensions? It lets you copy and paste in a list of member names from your clipboard and it will search the hierarchy for those members, no matter what level they're on, and select them for you.

http://olappivottableextend.codeplex.com/

Your question was how to do this programmatically. If you want to follow my code in that project but rewrite it in VBA, it's not a trivial amount of code, but it can be done. If you do attempt to write this in VBA yourself, if you know the MDX unique name for the members you're filtering to, it's much easier. Let us know if that add-in works for you or if you have to write this in VBA.

---

http://artisconsulting.com/Blogs/GregGalloway

Answer 4

Please find the link to connect item below:

ActiveX of pivot table drop-down

I know about the pivot extension, however it is not user friendly.

I am expecting a visual and easy to use functionality just as it is embedded in the olap pivot table.