+ Reply to Thread
Results 1 to 4 of 4

Disable Error Checking Rules

  1. #1
    Forum Contributor
    Join Date
    09-12-2021
    Location
    Mexico
    MS-Off Ver
    Office 2019
    Posts
    169

    Disable Error Checking Rules

    I have Excel 2019, and I'm able to disable Error Checking and Error Checking Rules by unchecking the relevant boxes. However, when Excel is restarted the boxes all contain checkmarks again.

    I'd like to make this action permanent, can someone please tell me how to do it? I have no use for all those little markings, triangles, etc than appear on Worksheets.

    Thanks for all suggestions.

  2. #2
    Valued Forum Contributor rollis13's Avatar
    Join Date
    01-26-2012
    Location
    Cordenons
    MS-Off Ver
    Excel 2016 32bit - Win 11
    Posts
    928

    Re: Disable Error Checking Rules

    Standard is to uncheck the boxes as needed and they stay like that till you check them again; don't even have to save a workbook. Just open Excel, goto the menu Options/Formulas, uncheck and close Excel, that's all.
    No idea why this isn't happening with your Excel. Maybe you need to repair your Excel.

  3. #3
    Forum Contributor
    Join Date
    09-12-2021
    Location
    Mexico
    MS-Off Ver
    Office 2019
    Posts
    169

    Re: Disable Error Checking Rules

    Many thanks Rollis. What you suggested worked, you always seem to have the right answer!

    Your help greatly appreciated, Happy 2022!

  4. #4
    Valued Forum Contributor rollis13's Avatar
    Join Date
    01-26-2012
    Location
    Cordenons
    MS-Off Ver
    Excel 2016 32bit - Win 11
    Posts
    928

    Re: Disable Error Checking Rules

    Glad I was able to help , best wishes for 2022.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Formula for checking against specific rules/requirements
    By Lauris K in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-19-2019, 09:21 AM
  2. [SOLVED] Disable formula error checking per spreadsheet
    By darxide23 in forum Excel General
    Replies: 5
    Last Post: 09-04-2015, 07:11 PM
  3. Error Checking Rules shortcoming
    By Bernie Deitrick in forum Tips and Tutorials
    Replies: 0
    Last Post: 08-07-2015, 01:15 PM
  4. Error Checking Rules shortcoming
    By Bernie Deitrick in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-07-2015, 01:15 PM
  5. Replies: 0
    Last Post: 03-13-2013, 12:05 PM
  6. Disable Error Checking for only a range
    By jomili in forum Excel General
    Replies: 2
    Last Post: 11-04-2010, 02:03 PM
  7. Error Checking rules
    By qwertyas in forum Excel General
    Replies: 6
    Last Post: 08-17-2010, 08:46 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1