+ Reply to Thread
Results 1 to 5 of 5

Data Validation missing on Excel for Mac

  1. #1
    Registered User
    Join Date
    07-20-2011
    Location
    London
    MS-Off Ver
    365
    Posts
    17

    Data Validation missing on Excel for Mac

    Hello,

    Excel for Mac issue
    I have an excel datasheet which contains staff hours worked. There is a simple dropdown list set up using data validation which was working perfectly until today. A few weeks ago i couldn't even open the file after updating the OS. When i select any of the cells there is no dropdown. I have tried adding data validation again but it makes no difference despite the link to the list i am using being present.

    Any ideas how to solve this?


    Using:
    Excel 15.28 on Macbook Pro macOS Sierra 10.12

  2. #2
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Data Validation missing on Excel for Mac

    Hi,

    Is the list on the same sheet as the data validation dropdown?
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  3. #3
    Registered User
    Join Date
    07-20-2011
    Location
    London
    MS-Off Ver
    365
    Posts
    17

    Re: Data Validation missing on Excel for Mac

    Its on a another tab, named as List. but had always worked just fine previously

  4. #4
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Data Validation missing on Excel for Mac

    Can you post the workbook? I can't test it on a Mac until later today unfortunately.

  5. #5
    Registered User
    Join Date
    07-20-2011
    Location
    London
    MS-Off Ver
    365
    Posts
    17

    Re: Data Validation missing on Excel for Mac

    Yeah sure... It seems that Data Validation is not working at all so wondering if it is some bug for my side....

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Compare two columns on separate sheet, if missing, insert missing data
    By lilvictorians in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 04-03-2019, 11:44 PM
  2. Data Validation not working,for excel validation Please Help!!!
    By angelmama in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-09-2014, 10:06 AM
  3. Data missing in WorkBooka after VBA Macro SAVE AS due to ComboBox source is missing
    By Purovagos in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-23-2014, 09:38 PM
  4. Excel Macro to find missing dates and insert missing date as blank row
    By JevaMarie in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-26-2013, 11:08 AM
  5. Macro to check for missing data and copy data if none missing
    By rosshkerr in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-03-2012, 05:24 PM
  6. Missing Drop Down list -Data Validation
    By abuelj1 in forum Excel General
    Replies: 5
    Last Post: 07-06-2006, 08:10 PM
  7. [SOLVED] Data Validation Dropdown Error - What am I missing? Seems like an
    By Rubyredvette in forum Excel General
    Replies: 2
    Last Post: 06-20-2006, 06:00 AM

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