Cannot refresh data

  • Thread starter Thread starter Grey
  • Start date Start date
G

Grey

I have designed a pivot table in excel with a range of data. Unfortunely,
the data in pivot table did not refresh when I added a new row of data in
the datasource. I need to make another pivot table for that range of data
including the new row. Is it possible to refresh data autmatically??

Million thanks
 
Grey,

When you add the data, you need to insert the new row or column within the
existing reference block of data.

For example, if your pivot table source is A1:D10, then to add a new row,
insert it by selecting A10 and using "Insert | Row" rather than just adding
the row of data to row 11.

Then, when you select your pivot table and press the refresh button, your
table will update properly.

If you have added your data by adding it below your table, simply select
your pivot table, and click the "Wizard" button on the toolbar, and click
"Back" twice to get back to the "define range" step of the pivot table
wizard.

HTH,
Bernie
MS Excel MVP
 
Back
Top