Pivot table auto refresh in excel sheet without using Macro/VBA while changing source data section data filter RRS feed

  • Question

  • Hi,

    Is there any possible way to achieve the below scenarios?

    1. Source data and pivot table are available in the same sheet.

    2. Pivot table get refresh automatically whenever am changing the source data section data filter. Is this possible in Excel sheet without using Macro or VBA?

    Please provide your response ASAP. this is an urgent request.

    Thanks in advance

    Tuesday, June 30, 2015 5:14 AM


All replies