Pivot tables stop updating

Copper Contributor
Hi.
I am using a spreadsheet with multiple pivot tables in it, twice now I have had to rebuild the sheet as the pivots stop updating when data is changed. When I refresh all there are no updates to the pivots. I need my data to be accurate but this is really messing things up for me.
If I change the data source and deselect the data in the table, the pivot will update once but not for any further changes.
Can anyone help with any reasons why this may happen and how things to try to resolve.
Apologies I cannot share the sheet due to the data in it.
2 Replies
What happens if you click refresh two times?
Can't you anonymize that data?