That setting is just below the Save Source Data check box.
The following topics provide instructions about how to manually refresh a data source and to edit its properties.
You can schedule data refresh to occur at regular intervals when you save a Power Pivot workbook to a Share Point site.
Change options, to save source data with pivot table file.
NOTE: For macros that help manage the source data, go to the pivot table source data macros page.
For regular Excel news, tips and videos, please sign up for the Contextures Excel newsletter.
Your email address will never be shared with anyone else.
These changes can include adding columns or tables, or changing the rows that are imported.
This topic provides the following information: Note that addition of data, changing data, or editing filters always triggers recalculation of any columns or formulas that depend on that data source. For more information, see If you need to update column metadata or get recent data for designing new formulas, you can manually refresh your data at any time.
NOTE: For a long term solution, use a named Excel table, as a data source.
It will adjust automatically, if new rows are added.
The written instructions are below the video, and you can download the sample file to follow along with the video.