![]() ![]() If you share the workbook with someone else and they open it on their system, the display of the "flags" is controlled by the setting on their system. Understand that turning off error checking in this manner affects only the way that Excel works on your own system. Clear the Enable Background Error Checking check box.Īny existing green triangles should disappear, and Excel stops checking for errors. ![]() The Formulas area of the Excel Options dialog box. Click Formulas at the left side of the dialog box.In Excel 2010 or later versions display the File tab of the ribbon and then click Options.) (In Excel 2007 click the Office button and then click Excel Options. If you don't want Excel to check for errors, you can turn the feature off by following these steps: This policy setting controls whether or not errors are reported to Microsoft.Error Reporting is used to report information about a system or application that has failed or has stopped responding and is used to improve the quality of the product.If you enable this policy setting users are not given the option to report errors. Right click on the Windows error reporting service from the list of services and then click on properties> there will be pop up screen > check for the startup type and select Automatic under drop down menu and apply the settings. If an error is located (or, at the least, what Excel thinks is an error), then the cell is "flagged" with a small green triangle in the upper-left corner of the cell. While you have Excel open, it is constantly checking in the background for potential errors in your worksheets.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |