Which Event Do You Use To Check If A Pivot Table Is Modified? – InterviewSolution

1.

Which Event Do You Use To Check If A Pivot Table Is Modified?

Answer»

EVENT 'PivotTableUpdate' in WORKSHEET CONTAINING that 'Pivot Table'.

Event 'PivotTableUpdate' in worksheet containing that 'Pivot Table'.

Discussion

No Comment Found

Related InterviewSolutions

How Will You Check The Memory Consumed By Your Pivot Table In Kilobytes?
Which Option Is Used To Add Column(s) In Pivot Tables To Compute The Values In Run-time? For Eg. If The Underlying Source Table Contains Cost Price And Sales Price, How Would You Compute 'profit'.
Which Event Do You Use To Check If A Pivot Table Is Modified?
How Can You Disable Automating Sorting In Pivot Tables?
Which 3 Report Formats For Pivot Tables Are Available In Excel 2007 Or Later?
How Can You Hide The Error Values In Data Field Of Pivot Table?
How Would You Enable Automatic Refresh In Pivot Table Upon Opening The Workbook Without Using Macros?
When You Link To A Pivot Table Cell, A Getpivotdata Formula Is Created. How Would You Avoid This?
Can You Change The Default Summary Function For Data From Count To Sum?
Upon Refreshing A Pivot Table, It Always Loses The Formatting Like The Column Width. How This Can Be Corrected?