Restore [Errors Checking Dialog] in Excel

Copper 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 menu & AlertError Checking menu & Alert

0 Replies