On 2002-04-27 05:30, kiwi wrote:
How can I get a pivot table to dynamically refresh/accept new rows that are added to the worksheet? The 'refresh data' option only seems to update the pivot table when existing data rows have been changed.
Thank you
Create a dynamic name range, say,
Data, and give this as
Range to your already created pivot table (PT):
Activate a cell within your PT.
Activate PivotTable Wizard that gives you a window entitled "PivotTable and PivotChart Wizard - Step 3 of 3".
Activate the Back button, which gives you "Step 2 of 3", showing Range with its current value.
Replace that current value with dynamic name range.
Next time to refresh while new rows added to your data, you'll see them included.
If you don't know how to create a dynamic name range, post the current range address of your data along with the kind of data (numbers, dates, or text) the range houses and the name of the sheet where your data is located.
Aladin