Error checking in Excel

Anonymous

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...

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

Anonymous

2018-10-05T10:30:39+00:00

Hi Jacsdad,

I would like to confirm with you if the "Turn on background error checking" is enabled automatically again?

Please try upload this workbook to OneDrive and open it in Excel Online and check if the error indicator keep show up.

Meanwhile, please put your cursor on the left little triangle and click on the caution icon, the reason why this error indicator show up will be listed at here. This will be a great help for us to investigate on this problem.

Also, I want to mention: disable "Turn on background error checking" permanently isn't the best way to solve the problem, we may also focus on the format of this workbook. So if it's convenient for you, please sent us this spreadsheet via PM.

Regards,

Alex Chen
Was this answer helpful?

0 comments No comments
Anonymous

2018-10-09T11:39:31+00:00

The problem comes and goes but is no longer consistent (each time I reboot). When the next version comes out, I will update all the Office products and see what happens.

I will post my results then.
Was this answer helpful?

0 comments No comments
Anonymous

2018-10-10T01:52:36+00:00

Hi Jacsdad,

We are really sorry for this issue keeps bothering you.

if it persist in the next Office updates, please let us know, we will be here for help.

Regards,

Alex Chen
Was this answer helpful?

0 comments No comments
Anonymous

2018-10-11T13:06:48+00:00

Good Morning... when the new version becomes available, I would like to install the updates in as clean of an environment as I can.

In an earlier conversation, it was recommended to remove the ~/Library/Preferences, locate the files com.microsoft.Excel.plist and com.microsoft.Office.plist. This cleaned up the situation for a while.

The Excel plist has moved to ~/Library/Containers/com.microsoft.Excel/Data/Library/Preferences/com.microsoft.Excel.plist. Is this location I should delete it from?

For the Office plist should I delete all references found in ~/Library/Preference/

com.microsoft.office.plist

com.microsoft.office.plist.09y6DwL

com.microsoft.office.plist.bL3SnNP

com.microsoft.office.plist.e2hHRM8

com.microsoft.office.plist.eOtKZ4Y

com.microsoft.office.plist.JjAhvH5

com.microsoft.office.plist.LNPP2BY

com.microsoft.office.plist.M7ZNCQr

Are there any other files I should remove?

Thanks ahead of time...
Was this answer helpful?

0 comments No comments
Anonymous

2018-10-12T12:21:29+00:00

Hi Jascdad,

These plist files will be created automatically when you open the related Office Product.

Since these files store your preferences, Office updates won't change these plist files.

So if you want to perform a clean environment to install the Office update, we would recommend you first completely uninstall your current Office product following this article. And download the latest version of the Office installation package in your Portal.

Meanwhile, you can check the newest Office updates and download them at Update history for Office for Mac.

Regards,

Alex Chen
Was this answer helpful?

1 person found this answer helpful.

0 comments No comments