Forum Discussion

oermens's avatar
oermens
Copper Contributor
Dec 29, 2021

Pivot table cannot be refreshed in excel 2019

Hi, I can't refresh my pivot table. as soon as I put new data in my "main sheet" and then click refresh or refresh all, nothing happens in my pivot table. I use office 2019.
excel
NikolinoDE's avatar
NikolinoDE
Platinum Contributor
Dec 29, 2021

oermens 

Maybe this link will help you.

Refresh PivotTable data

 

a approach would be...

Go to “PivotTable” in the Pivot Tables menu
2. Read out options
3. Read out options again (you should do it twice, if you do it once it usually doesn't work)

Instead of unfolding the “Options” with the little arrow in 2. and then continuing with step 3., you can also click on the word “Options” in step 2. and you are in the same setting dialog as according to these instructions after step 3. only . 🙂

 

or automatically update with VBA code when opening the workbook.

Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
    ThisWorkbook.RefreshAll
Application.EnableEvents = True
End Sub

After this solution has been implemented, the pivot table is automatically updated every time a change has been made on the worksheet of the pivot table.

The only problem that remains is if the data source of the PT is linked to an external source (e.g. database, etc.) ... then you still have to carry out a manual update, as Excel cannot know that something has changed in the information.

 

 

Hope I was able to help you with this info.

 

Nikolino

I know I don't know anything (Socrates)

 

Resources