Excel Application Calculates before checking Data Validation

[monakelkar]

Is there a way to stop excel from calculating BEFORE it runs the data entered through data validation rules? I don't want users to see a mess on the screen.

I have an excel sheet with various data validated cells. Excel is correctly throwing the Stop Error alert when incorrect data is entered, but it calculates the book and shows a mess of #N/As and #VALUEs where the invalid data is referenced.

I've considered/tried (and would like to avoid) the following solutions:

• Iferror() wrappers - all formulas will revert to 0s or blanks, which is equally undesirable
• Using the worksheet_change routine, and turning screen updating off, and turning to manual calc - it always seems to conveniently freeze after all the #N/As pop-up

Thanks in advance for any help!

 

[konew1]

On the data validation setup,"Error Alert" and ensure you check box for "Show error alert after invalid data is entered"

 

[monakelkar]

Thanks. I have that checked but the workbook still calculates in the background - it eventually reverses once the error message pops up. I'm trying to prevent the temporary calculation it does in the background.