Forum Discussion

Taylor_Machette's avatar
Taylor_Machette
Copper Contributor
Aug 13, 2019

Formula incomplete error won't close

Hello,

 

I accidentally typed a "-" sign into an empty cell, and excel is returning the error message "Your formula is incomplete." The only option for this warning is to press the "OK" button; however, when I do this, it immediately brings the message back up again. I can't access any of my other spreadsheets, and the application itself won't quit, either. Any idea on how I can get rid of this message if the button to close it isn't doing anything? Such a small thing is causing all of Excel to have a fit!

 

Thank you

excel
Formulas and Functions

4 Replies

    • Taylor_Machette's avatar
      Taylor_Machette
      Copper Contributor
      Aug 13, 2019

      Hi PReagan ,

       

      Yes, I have. That doesn't do anything but make a loud error noise on my Mac, unfortunately.

      • PReagan's avatar
        PReagan
        Bronze Contributor
        Aug 13, 2019

        Taylor_Machette,

         

        Unfortunately, I have a PC so I cannot replicate your issue. However, I came across this possible solution:

         

        https://answers.microsoft.com/en-us/msoffice/forum/all/stuck-in-error-message-loop/ccdb1ab5-1b44-4c0c-a3e0-c399cca78f91

         

        Hope this helps!

        PReagan

Resources