How Do You Provide Dynamic Range In 'data Source' Of Pivot Tables? – InterviewSolution

1.

How Do You Provide Dynamic Range In 'data Source' Of Pivot Tables?

Answer»

We follow the steps in following order to provide Dynamic RANGE in 'Data Source' of PIVOT Tables:

Create a Named range using Offset function.
BASE the pivot table using the Named range CREATED in STEP 1.

We follow the steps in following order to provide Dynamic Range in 'Data Source' of Pivot Tables:

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?