Hi,

As per my requirement, I have one excel sheet with one normal table with almost 10 columns,
From that table, i created one Pivot Table using three of its columns.

I want a solution to Refresh the Pivot Table automatically when I filter the source table.
Note: No Macros are allowed

Thanks In Advance.
MeAnj

• Edited by MeAnj Monday, June 29, 2015 3:05 PM
• Moved by Cindy Meister MVPMVP Monday, June 29, 2015 5:39 PM not developer-related

Hi MeAnj,

Based on your description, it seems that your PivotTable can't refreshed automatically.

I tested your requirement in my own environment, I found if the PivotTable was created with the source table in the same workbook it can be refreshed automatically without any other settings. 

Then I created 2 workbooks, workbook1 contained the source table and the PivotTable was created in workbook2. I can't refresh the PivotTable automatically any more when I filtered the source table in workbook1.

How did you create the PivotTable? Please provide the steps of creating the PivotTable so that I can provide more accurate solutions to this problem.

Im glad to help and follow up your reply.

Regards,

Emi Zhang
TechNet Community Su