Forum Discussion

Gosmann's avatar
Gosmann
Copper Contributor
May 24, 2020

What-if analysis does not work

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?

excel

1 Reply

  • bhushan_z's avatar
    bhushan_z
    Iron Contributor
    May 24, 2020

    Gosmann refer below screenshot.

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