Feedback by UserVoice

Anonymous

My feedback

  1. 900 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    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!

    Thanks

    Ashvini Sharma
    Lead Program Manager
    Excel

    Anonymous commented  · 

    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  · 

Feedback and Knowledge Base