Correlation Matrix Values Not Updating

[hcour]

I created a simple correlation matrix using the Data Analysis Correlation tool. It comes up fine initally but does not update when I change the source data. I've googled but no solutions worked. I have Automatic Calculations checked and the sheet isn't protected and the source data is formatted as numbers. Values in other calculations are updating, for instance in my Budget sheet, they update instantly when data is changed.

I just bought Office 2021 on the Black Friday deal. I was using 365 previously and it was working fine, if that has any bearing.

Thanks.

 

[hcour]

Hmm. Well, I was able to solve the problem with a workaround, using the Solver and Real Statistics add-ons. Good enough.