Correlation Matrix Values Not Updating

hcour

Board Regular
Joined
Feb 28, 2014
Messages
50
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.
 

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.
Hmm. Well, I was able to solve the problem with a workaround, using the Solver and Real Statistics add-ons. Good enough.
 
Upvote 0
Solution

Forum statistics

Threads
1,216,099
Messages
6,128,820
Members
449,469
Latest member
Kingwi11y

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top