Forum Discussion

Daria Mercurio's avatar
Daria Mercurio
Copper Contributor
Feb 17, 2018

My excel has stopped giving me a drop menu and it will not calculate and I am not in text

I am not in text but general and I am in automatically calculate but my functions in excel is no longer giving me a drop down and no longer calculating

2 Replies

  • Willy Lau's avatar
    Willy Lau
    Steel Contributor

    This may be a result of incorrect formula/formula with errors being used in the formula of the drop down list.

     

    Copy your drop down list formula to a cell and trace if it is correct.

  • None None's avatar
    None None
    Copper Contributor

    me too! Cant get auto sum to work and the totals have disappeared from the bottom green bar!