I have a spreadsheet where I manage expenditure from my bank accound (and cannot therefore share the data).
At the end of every month I copy the data to a new sheet and transform some of the data (I change negative valued to positive values)
I then take the transformed and copy it and paste/append it to an existing table of previous transactions.


I then have several Pivot tables to collate the data.

I've been doing this for years without issue, except for this month. When I refreshed the Pivot Tables, the new data was not included and I noticed that the Slicer did not include the month for the latest data.

I've done the following checks:-
The new data appended to the base table is included in the table range
The date is in the correct format dd/mm/yyyy