Share via

Is this an Excel BUG?

FH frank ho 0 Reputation points
2024-01-29T15:36:35.1666667+00:00

Hi, First, Set A1="Male", A2="Female" in an Excel sheet and name "Sex=$A$1:$A$3".

  1. In the data validation dialog box for B1, specify "Allow"="Sequence", "Source"="=Sex". Then enter "Any" in B1 can pass the data validation.
  2. However, if you specify "Source" = "=$A$1:$A$3" in the data validation dialog box of B1, the data validation cannot be passed when you enter "Any" in B1.
  3. This is not the case for "Sex=$A$1:$A$2".

Thanks!

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,694 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emi Zhang-MSFT 23,906 Reputation points Microsoft Vendor
    2024-01-30T02:26:33.6333333+00:00

    Hi,

    I can reproduce this behavior in Excel, it seems this is by design behavior.

    If you have any feedback or suggestion about this behavior, you can try to give a feedback to Microsoft about your requirement:

    https://support.microsoft.com/en-us/office/how-do-i-give-feedback-on-microsoft-office-2b102d44-b43f-4dd2-9ff4-23cf144cfb11

    Microsoft values your opinion. Your feedback goes directly to our engineers and helps us shape the future of Microsoft products and services for all our users.

    If the response is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments