771 votes124 comments · Excel for Windows (Desktop Application) » Tables, Sorting and Filtering · Flag idea as inappropriate… · Admin →
Thanks for logging this great suggestion, Zack, and to others for voting it up. We’ll prioritize this according to the number of votes, so if there’s more interest, please make sure to register your vote!
Lead Program Manager
Accepting data validation is a flawed solution you can use the method and simplify application.
In the first data row of the table select all the cells that contain formulas.
Set data validation for all of them in one go.
On settings tab allow Custom, untick the ignore blanks box.
In the formula box type, "This cell contains a formulas - do not change it".
Select this text and copy it.
On the Input Message tab paste this same text as the Input message.
On the Error Alert tab paste this same text as the Error message.
Unless your user tries to type in, "This cell contains a formulas - do not change it", they will fail and get a helpful message.
They can still copy and paste something in to the cell and bypass the check.
I am thinking even if MS do sort out table protection this is still quite a useful thing to do.
Also isn't copy and paste not only over ruling data validation but deleting data validation a problem that needs to be fixed anyhow?Anonymous supported this idea ·