Same Data Validation not working in some excels

Anonymous
2025-02-05T09:44:13+00:00

I am downloading and prefilled excel sheet with already set data valitations. in my excel the dropdown is not listing for other attributes but when others try with the same excel they can list. And I also get an unkown error in data validation. Attaching correct and false screenshots. Anyone experienced this issue? (doesnt differ from mac or android)
correct one excel version 16.42
false one excel version 2501

Microsoft 365 and Office | Excel | Other | Android

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 No comments
{count} vote

6 answers

Sort by: Most helpful
  1. Anonymous
    2025-02-21T09:34:16+00:00

    Hi, Asya Kırkaya

    I didn't encounter any problems when opening your file during testing, so I guess it might be the impact of your computer environment? :-)

    Are you using a third-party firewall? If so, you can try to turn it off.

    Then you can try to open Excel in safe mode (to rule out interference from third-party software):

    Open Office apps in safe mode on a Windows PC - Microsoft Support

    I hope the above information can help you. Feel free to send a message if you need further help.

    Best wishes

    Aiden.C - MSFT |Microsoft Community Support Specialist

    0 comments No comments