Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Say I have a pivot table in sheet2 and the raw data is from sheet1. Is there any way that let me can add more rows to sheet1 periodically and the pivot table still can auto update?

share|improve this question
up vote 1 down vote accepted

Make your data range on Sheet1 a List. Then make sure your pivot table's data range is the list, not just a cell range. This is automatic if you make your pivot table from an existing list.

When you add data to a list, the list automatically grows. All you need to do is hit Refresh on your pivot table and it will reflect any changes/additional data in the list.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .