Click here to Skip to main content
15,867,308 members
Please Sign up or sign in to vote.
1.00/5 (2 votes)
Hi,

As per my requirement, I have one excel sheet with table having 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.
Anjali
Posted
Updated 29-Jun-15 5:05am
v2

1 solution

This functionality is available starting from Excel 2010. See: Overview of PivotTable and PivotChart reports[^]
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900