What-if analysis does not work

Copper Contributor

Hi Microsoft

 

Neither my Mac nor PC works with What-If Datatabel analysis in Excel.

 

My computer returns the same number in all the cells and does not calculate anything. What can I do to change this?

1 Reply

@Gosmann refer below screenshot.

Make sure highlighted numbers are saved as 'Values" and are not connected to any other cells via "Formulas"

 

bhushan_z_0-1590389419355.png