none
DataModel : Hide from clients tools RRS feed

  • Question

  • Hello there,

    is it possible to Hide some datasets in the DataModel PowerPivot using C# interop (or VBA) ?

    (like right clic->hide from client tools)

    Thanks !

    Fabrice

    Tuesday, March 20, 2018 2:40 PM

All replies

  • Hello Fabrice,
    >> Hide some datasets in the DataModel PowerPivot
    What does it mean? Where did you right click to hide from client tools? A sample screenshot that illustrates the desired result or behavior would be greatly appreciated. 

    Best Regards,

    Terry



    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Wednesday, March 21, 2018 2:18 AM
  • Hi Terry,

    Thanks for your answer !

    In attach, a screenshot from PowerPivot where you can see what I want to do programmatically. Hide From Clients Tools will hide the dataset in the pivot tables.

    Is it clear now ? Do not hesitate to ask more questions. :)

    Have a great day

    Fabrice

    Wednesday, March 21, 2018 7:36 AM
  • Hello Fabrice,

    Thanks for sharing the screenshot.

    The Hide from Client Tools option is provided by an add-ins "Microsoft Power Pivot for Excel" which is not open source for editing. So I think it is not possible to call the function in progarmmatically.

    Thanks for understanding.

    Best Regards,

    Terry


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Friday, March 23, 2018 8:56 AM