Why pivot table is not refreshing data

By continuing to use this website, you agree to their use. Connect anytime to free, instant, live Expert help by installing the Chrome extension Add Excelchat to Chrome.

Quick Excel Help. Get instant live expert help with Excel or Google Sheets. Post your problem and you'll get expert help in seconds Your message must be at least 40 characters. Our professional experts are available now. Your privacy is guaranteed. Connect to an Expert. How to Update a Pivot Table in Excel In Excel, when we add data or make changes in the source data set, the Pivot Table does not pick up these changes automatically in the data set.

We need to refresh the Pivot table manually as standard functionality in Excel to update the Pivot table results with these changes in source data. In this article, we will learn how to refresh the Pivot table in Excel manually to update Pivot Table results. Changing data in source data set When we change any text or number in existing source data range, then this change is not automatically captured in the Pivot Table, so we need to refresh the Pivot table manually.

Adding or deleting data in source data When we add or delete data in a source data by adding or deleting rows and columns, then we need to refresh the Pivot table.

Source data can be changed in two ways; Manually Change Data Source: After adding or deleting data from source data, we can manually change data source in a Pivot table to refresh the Pivot table.

In this tutorial, we will take a look at some of those situations and how to correct them, so that changes to your original data get updated in the Pivot table too. If you find that your Pivot tables are not getting refreshed automatically whenever you make changes to the original dataset, it may be due to one of the following reasons:. Let us take a look at each of the above situations, why they happen, and how to solve them one by one.

The Pivot table works with data from a particular range of cells in your original worksheet. And that obviously makes sense, since the new range does not fall into the range that the Pivot table was built to pull data from. When initially creating your pivot table you can use a little foresight and add some extra rows for data you are likely to add in the future.

For example, if your data currently spans over 20 rows, you can create your pivot table with rows. Can you help us improve? Resolved my issue. Clear instructions. Easy to follow. No jargon. Pictures helped. Didn't match my screen. Incorrect instructions. Too technical. Any ideas? Excel Facts.

Will the fill handle fill 1, 2, 3? Click here to reveal answer. GraH Well-known Member. Hi, couple of extra questions. Why is the whole source data not a single table? You say, right click on the data and refresh. Then the data is external, or do you mean right click on the pivot?

That 2nd point is suspicious, that's why I ask. If your data needs to be refreshed separately and before the pivot refresh, simply checking the option in the pivot properties won't do.

I don't know. I inherited this tool from others who are more experienced in Excel than I am, so I'm sure there's a reason, I just don't know what it is.

My apologies -- I misspoke. I meant right click on the pivot. Can't imagine a good reason right away How does that resize correctly? VBA involved? Okay, mystery How is the source date expanding? I mean, why is it needed to refresh on open? Are there other events happening as well?