Forum Discussion

jeffharrellyo's avatar
jeffharrellyo
Copper Contributor
Aug 11, 2020

Help with an error message

The attached message pops up on every spreadsheet I open and it's driving me nuts.  

 

I've deleted Excel and reloaded, and still get the same error. 

 

Any help would be GREATLY appreciated!

7 Replies

  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor
    Unfortunately I cannot help you any further. A Mac Excel specialist is required.

    Nikolino
    I know I don't know nothing (Socrates)
  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor

    jeffharrellyo 

     

    Try it with Conditional Formatting -> Delete Rules -> Delete Rules in Entire Sheet.

    Ref errors are mostly hidden in the conditional formatting, which can be eliminated.

     

    I would be happy to know if I could help.


    Nikolino
    I know I don't know nothing (Socrates)

    * Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

    * Beware of scammers posting fake support numbers here.

    • jeffharrellyo's avatar
      jeffharrellyo
      Copper Contributor
      I thought this was going to work but still getting the same error message. Ugh!
  • jeffharrellyo I have suggestions for you as below to fix this:

     

    * First Go To Formulas >Then Name Manager

    * Once you see the window here you will see all references listed as formula error, just Delete those

    * Still you get the error, press Control + F key and find "#". It will how you all the cells where Formula errors are there. So you need to go and fix those.

     

    Hope this will help

     

    Thanks

    Kapil

    • jeffharrellyo's avatar
      jeffharrellyo
      Copper Contributor

      jukapil 

       

      Thanks for the try but unfortunately still  has the error message.  This one is frustrating.

Resources