unable to update pivot tables on Mac

[Jo-AnnDP]

I am trying to change the selection to include 2024 but I can't find the option anywhere. I'm using a MacBook Air. Can anyone help me please?

[#2 · Accepted solution]

@Jo-AnnDP Did you expand the source data for the pivot table/chart to include data for 2024?

[#3]

thanks so much, as soon as I posted this I managed to figure out what I'm doing wrong