Share via

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

6 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2025-02-06T05:26:18+00:00

    Hi, Asya Kırkaya

    Thank you for using Microsoft products and posting them to the community.

    In the screenshot of your error, you are referencing what looks like a defined name, you can go to the formula-name manager to see if the name is there or if there is data under that name.

    If it doesn't, it will report the error.

    Then for more information, I may need to check and investigate your file, if it's convenient, could you share your file?

    Why a sample file is important for troubleshooting. How to do it. - Microsoft Community

    Looking forward to your reply.

    Best wishes

    Aiden.C - MSFT |Microsoft Community Support Specialist

    0 comments
  2. Anonymous
    2025-02-06T06:46:06+00:00

    Hello Aiden thank you for your reply.

    Here is the link for the file https://www.dropbox.com/scl/fi/0vasmad6q89zheym6it2o/Product_2025-02-05_1126.xlsx?rlkey=ym71ngky7hdawfdw6q2v00n98&st=99swwie4&dl=0 

    Please note that same sheet is working for other users.

    Best,

    0 comments
  3. Rory Archibald 18,765 Reputation points Volunteer Moderator
    2025-02-06T08:15:43+00:00

    If you type =SheetName into a cell in the workbook that doesn't work, does it return a value or an error?

    0 comments
  4. Anonymous
    2025-02-14T11:58:18+00:00

    Hello Aiden,

    This worked as a workaround, so thank you! I was able to list the attributes and then reselect them in data validation, and now they are correctly listed.

    However, do you know why the same attribute mapping isn’t working, even within the same excel version? The list will continuously change, and I’d prefer not to repeat these manual steps every time.

    Best,

    1 person found this answer helpful.
    0 comments
  5. Anonymous
    2025-02-06T08:28:09+00:00

    Hi, Asya Kırkaya

    Hold down Alt+F11, open the VBA editor, then select Sheet4, select this one in the picture, then select Visible, and change the 2 - xlSheetVeryHidden on the side to -1 - xlSheetVisible so that the hidden worksheet will be visible.

    Check your hidden worksheet, are there any anomalies or is the data normal? The file I opened shows the following:

    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