Home

Restore [Errors Checking Dialog] in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-457161%22%20slang%3D%22en-US%22%3ERestore%20%5BErrors%20Checking%20Dialog%5D%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-457161%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20using%20Excel%20for%20Mac%20(vs.%2016.23)%20(190309).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETo%20figure%20out%20which%20category%20caused%20my%20formula%20to%20trigger%20a%20warning%2FError%3C%2FP%3E%3CP%3EI%20un-ticked%20all%20the%20Error-kinds%20check-boxes%20in%20the%20Check%20Error%20Dialog%20Window.%3C%2FP%3E%3CP%3EThe%20intention%20was%20to%20restore%201%20by%201%20to%20see%20which%20was%20the%20kind%20of%20error-check%3C%2FP%3E%3CP%3Eto%20fail.%3C%2FP%3E%3CP%3ENow%20I%20cannot%20reopen%20that%20Dialog%20Window%20anymore%20(to%20start%20the%20ticking%201%20by%201).%3C%2FP%3E%3CP%3EThe%20%22Error%20Checking%20...%22%20menu%20just%20opens%20an%3C%2FP%3E%3CP%3E%3CSTRONG%3E'Alert'%20%3A%20%22The%20error%20check%20is%20complete%20for%20the%20entire%20sheet.%22%26nbsp%3B%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3Ewith%20an%20%5B%3CSTRONG%3EOK%3C%2FSTRONG%3E%5D%20button%20only%20available.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENot%20sure%20if%20it's%20a%20bug%2C%20anyhow%20the%20code%20to%20open%20that%20Dialog%20Window%20seems%20to%20have%20been%20cut%20out.%3C%2FP%3E%3CP%3EAny%20idea%20how%20to%20reopen%20that%20Dialog%20from%20somewhere%20else%20%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20style%3D%22width%3A%20432px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F108974i3B1C725F9FD54491%2Fimage-dimensions%2F432x240%3Fv%3D1.0%22%20width%3D%22432%22%20height%3D%22240%22%20alt%3D%22Error.Checking.png%22%20title%3D%22Error.Checking.png%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EError%20Checking%20menu%20%26amp%3B%20Alert%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-457161%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
stv1vy
New Contributor

I'm using Excel for Mac (vs. 16.23) (190309).

 

To figure out which category caused my formula to trigger a warning/Error

I un-ticked all the Error-kinds check-boxes in the Check Error Dialog Window.

The intention was to restore 1 by 1 to see which was the kind of error-check

to fail.

Now I cannot reopen that Dialog Window anymore (to start the ticking 1 by 1).

The "Error Checking ..." menu just opens an

'Alert' : "The error check is complete for the entire sheet." 

with an [OK] button only available.

 

Not sure if it's a bug, anyhow the code to open that Dialog Window seems to have been cut out.

Any idea how to reopen that Dialog from somewhere else ?

 

Error.Checking.pngError Checking menu & Alert

Related Conversations