Register now or log in to join your professional community.
To provide a dynamic range in “Data Source” of Pivot tables, first create a named range using
offset function and base the pivot table using a named range created in the first step.
