Error checking in Excel

Anonymous
2018-10-01T12:44:25+00:00

I have been using the same excel spreadsheet for over a year, without any problems.  For the past coupe of days, a column I have formatted as Number/Special/Zip Code, places an error (triangle in the upper left corner of most cells (but not all) in that column only.   

I go to the Excel Preferences/Error Ckecking and remove the checkmark in the 'Turn on background error checking' and the error indicator disappears until I shutdown and reboot (I can file the document and open it again, without problems).

This is on an iMac (Retina 5k 2017), running the macOS Mohave Version 10.14 with Office 365 with Microsoft Excel for Mac Version 16.17.

Any suggestions would be appreciated...

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

43 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2018-11-20T18:39:57+00:00

    Alex... I agree, this my not belong here.  Can you suggest where I should seek the help?  The page you reference will not allowmupdates.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2018-11-20T08:18:47+00:00

    Hi Jascdad,

    Since this thread has been lasted for over a month. To help us understand your current situation better, I will try making a summary. Please help us point out the misunderstanding part.

    In my opinion, your current issue is about the error indicator show up continually. If you uncheck "Turn on background error checking", the error indicators will temporary disappear, but will come back after your reboot your Mac.

     

    If this is your situation, I would like to ask you to check if "Turn on background error checking" is enabled automatically every time you reboot your Mac. If so, then your issue should be "Excel Preferences won't save".

    Per my research, I found a user with similar issue: Problem: Excel Preferences settings keeps reverting to default.

    This user figure it out by creating a new user profile on his Mac. Please try this method and check if it helps in your scenario.

    Disclaimer: Microsoft provides no assurances and/or warranties, implied or otherwise, and is not responsible for the information you receive from the third-party linked sites or any support related to technology.​​

    If you have checked that "Turn on background error checking" remain uncheck after reboot your Mac, but the error indicator keep showing up, then, like I mentioned in my former reply, it's might be a file related issue, if it's convenient for you, we would like a copy of this Workbook via Private Message, so we can further investigate on this issue.

    Regards,

    Alex Chen

    Was this answer helpful?

    0 comments
  3. Anonymous
    2018-11-19T13:48:39+00:00

    Alex... here is the attachment:  

    I can recreate the situation by going into Excel Preferences, Error Checking uncheck Turn On Error Checking (error indicatords disappear).  After I am finished with my updates to the workbook. file it and shutdown the system.  When I restart the system, the situation occurs again.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2018-11-19T09:23:05+00:00

    Hi Jacsdad,

    I would like to confirm with you, if the error indicators show up again on the zipcode cells.

    If so, please provide this workbook to us via Private Message. It will be a great help for us to further troubleshoot on this issue.

    Regards,

    Alex Chen

    Was this answer helpful?

    0 comments
  5. Anonymous
    2018-11-18T14:30:17+00:00

    Mr. Gordon... yesterday, it began again.  Currently my system is running:

    macOS Mojave Version 10.14

    Excel Version 16.19

    I have CleanMyMac Version 13.10.o and Malwarebytes Version 3.14.29.

    Was this answer helpful?

    0 comments