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 16 hours 23 minutes ago
• Moved by Cindy Meister MVPMVP 13 hours 49 minutes ago not developer-related

If no macros are allowed, then you've posted in the wrong set of forums: MSDN forums are specifically for programming (coding). I'll move your question to the IT Pro forum on the TechNet server...