+ Reply to Thread
Results 1 to 6 of 6

Excel Message: "The value you entered is not from the required list"

  1. #1
    Registered User
    Join Date
    04-09-2013
    Location
    Birmingham, Alabama, USA
    MS-Off Ver
    Excel for Mac 2011, Version 14.1.4
    Posts
    2

    Excel Message: "The value you entered is not from the required list"

    I just signed up for this forum (4/9/13). I am a Mac user and a long time user of MS Office for Mac. I live in Alabama, am retired, and a Senior Citizen. Usually I am able to solve my own user problems regarding the software in MS Office for Mac. However, I need help with the problem associated with the descriptive title.

    PGutt

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,320

    Excel Message: "The value you entered is not from the required list"

    it sounds as though you are entering a value that does not match the validation set on the cell
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  3. #3
    Registered User
    Join Date
    04-09-2013
    Location
    Birmingham, Alabama, USA
    MS-Off Ver
    Excel for Mac 2011, Version 14.1.4
    Posts
    2

    Excel Message: "The value you entered is not from the required list"

    I have one column in my spreadsheet where I enter both text and numbers. The possible text entries are limited to a total of five entries, while the numbers are incremental (1810, 1811, 1812, and so on). When I try to enter a number, I get the message:"The value you entered is not from the required list" with the options to Cancel or Retry. Trying again gives the same result, and I am unable to enter a number in any cell of that column. Can anyone help me resolve this?

    Thank you,

    PGutt

  4. #4
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    2013
    Posts
    5,454

    Re: Excel Message: "The value you entered is not from the required list"

    Hi

    Did you create the spreadsheet?

    It sounds like there is a macro that is preventing you from entering values.

    right click on the name tab at the bottom of excel and select view code..

    I don't think it can be data validation but I am investigating.
    Last edited by mehmetcik; 04-09-2013 at 04:19 PM.

  5. #5
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    2013
    Posts
    5,454

    Re: Excel Message: "The value you entered is not from the required list"

    Hi

    Custom validation would block numbers too.

    if you select cell A1 then custom data validation and type this formula into the formula box
    Please Login or Register  to view this content.
    then excel will only accept text.
    Last edited by mehmetcik; 04-09-2013 at 04:36 PM.

  6. #6
    Registered User
    Join Date
    03-20-2017
    Location
    Houston
    MS-Off Ver
    MS Office 11 for MAC
    Posts
    1

    Re: Excel Message: "The value you entered is not from the required list"

    PGutt: I also work on a Mac, and have Excel for Mac 2011...after fiddling around some, I found out this works:

    Click the following:
    Edit==>Clear==>All

    This will clear out the values in the table or drop-down list, and allow you to enter a different value.
    You can also delete Formats, Contents, and Comments, but the above works if you have a list or table that dictates the values.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1