save pivottable template RRS feed

  • Question

  • hy

    i want please to use : defer layout update (checks), and pulldown fields 

    ( i want that the data will not be loaded yet)

    and after to save this template and  reopen the excel and load now the data is't posibble? (mean to click update button using vba)

    oren t

    Sunday, March 1, 2015 2:54 PM


  • Hi oren trug,

    According to the descrption, you want to use macro to update the layout of pivot table.

    As far as I know, the Excel object model doesn't provide such API to achieve the goal. If you want Excel object model supports this feature, I suggest that you submit a feedback from link below:
    Submit Feedback - Microsoft Support

    Also here is the document for the PivotTable object for your reference:
    PivotTable Members (Excel)

    Regards & Fei

    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Tuesday, March 3, 2015 3:13 AM