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: Newest
Most helpful Newest Oldest
  1. Anonymous
    2018-10-01T16:34:34+00:00

    Dear Jacsdad,

    Could you please share the screenshot of error that you are getting?

    Please check for updates https://support.office.com/en-us/article/troubl...

    Looking forward to your reply!

    Was this answer helpful?

    0 comments
  2. Anonymous
    2018-10-01T15:41:36+00:00

    The instructions described are for the Mac OSX Yosemite version and the file Com.microsoft.officeprefs.plist is nowhere in the Group Container.  I am running macOS Mohave Version 10.14, so I am apprehensive about using outdated instructions.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2018-10-01T12:54:30+00:00

    Dear user,

    Please try the suggestions from this article https://support.microsoft.com/en-gb/help/975724...

    Please share the results!

    Was this answer helpful?

    0 comments