This video explains how to use Excel's OFFSET function to create a PivotTable range that autoamatically expands to incorporate new records.
------------------------
On this page of the site you can watch the video online Creating a Dynamic Range for a Pivot Table Using the Offset Function with a duration of hours minute second in good quality, which was uploaded by the user Chester Tugwell 13 August 2012, share the link with friends and acquaintances, this video has already been watched 58,725 times on youtube and it was liked by 214 viewers. Enjoy your viewing!