Share via

Excel Office 365 - Data validation is not available on Data ribbon

Anonymous
2020-08-25T14:58:49+00:00

Excel Office 365 - Data validation is not available on Data ribbon

Version 2007 (Build 13029.20344)

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

5 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  2. Anonymous
    2020-08-25T16:10:21+00:00

    Hi Jessica,

    There was a support spam post in this thread, please do not call the number they provided. 

    I just checked the same Excel version as you mentioned, but the data validation button is listed on my ribbon.

     

    The first thing you need to check is whether you have disable the data validation button in the customize ribbon option. Please go to File > Options > Customize Ribbon, change to all commands, find Data Validation button and add it to the ribbon.

    Or, if you haven't made any customization on your ribbon, you could just check the reset button to reset your ribbon to the default settings, see if that helps. 

     

    Regards,

    Alex Chen

    9 people found this answer helpful.
    0 comments
  3. Anonymous
    2020-08-25T16:23:33+00:00

    Hi Alex, 

    I did review the Customize Ribbon and reset the Data Tools (including Data Validations).

    Then, I was expecting to see the option displayed in Data Ribbon but it doesn’t, even do, I'm able to open the Data Validation option through the search option.

    Thank you!

    Jessica Franco.

    0 comments
  4. Anonymous
    2020-08-25T21:10:09+00:00

    Hi Jessica,

    Try using Online Repair to fix your Excel's components. 

    Repair an Office application

    Since resetting the customize ribbon didn't solve the issue, I assume this issue might be related with the corrupted Office components.

    Please let us know if there are any updates. 

    Regards,

    Alex Chen

    0 comments
  5. Anonymous
    2020-08-27T22:10:23+00:00

    Hi Jessica,

    Have you tried the Online Repair as I suggested?

    Did that fix the issue?

    Regards,

    Alex Chen

    0 comments