Excel VBA Pivot data source change RRS feed

  • Question

  • Hi I currently have 5 data connections in my excel file. All of them contain the same data including headings however the aggregation is different ie one is daily one is weekly, monthly and so in. I have a pivot linked to the daily one and I don’t want to creat a pivot for each. How can I using Vba change the pivot source data ? I will I have 5 buttons when user selects daily it will change pivot link to daily source and so on.

    Wednesday, June 10, 2020 12:39 PM

All replies

  • Hi,

    Since this forum focuses more on questions related to Office desktop applications, if you need further assistance on this problem, I'd like to help you move the thread to the following forum: Excel for Developers forum. You may get more helpful replies there.

    The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thanks for your kind understanding.

    Best Regards,


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Office 2019.

    Thursday, June 11, 2020 2:17 AM
    • Thankyou
    Friday, June 12, 2020 12:25 PM