Updating data in pivot table
However, if the source data has been changed substantially—such as having more or fewer columns, consider creating a new Pivot Table.To change the data source of a Pivot Table if it's a range of cells or an Excel table, do the following: Tip: Leave the dialog box open, and then select the table or range on your worksheet.I add rows of data periodically, but they are not reflected in my pivot table, even after refreshing data from the ribbon bar.I have tried to create new pivot tables expanding the range of rows to over compensate, but then the pivot table layout is different and difficult to use.
Worksheets("Sheet1") ' Dynamically Retrieve Range Address of Data Set start Point = data Sheet. Microsoft is conducting an online survey to understand your opinion of the Technet Web site.Ideally I would like to be able to do some kind of search and replace operation (like you can do on formulae), rather than updating each individual pivot table by hand. Sub Change_Pivot_Source() Dim pt As Pivot Table For Each pt In Active Workbook. Sub Adjust Pivot Data Range() Dim pt As Pivot Table, pc As Pivot Cache Dim data Sheet As Worksheet, ws As Worksheet Dim start Point As Range, data Source As Range, new Range As String ' get worksheet with data Set data Sheet = This Workbook. Special Cells(xl Last Cell)) new Range = data Sheet. Create _ (Source Type:=xl Database, Source Data:="Data2") Next pt End Sub Assuming you're willing to use VBA, this might be relevant. After you create a Pivot Table, you can change the range of its source data.
For example, you can expand the source data to include more rows of data.