+ Reply to Thread
Results 1 to 4 of 4

Validation list from Mac Excel 2011 fails to function on Windows 7 Excel 2010

  1. #1
    Registered User
    Join Date
    12-14-2012
    Location
    Kamloops, BC, Canada
    MS-Off Ver
    Excel 2011
    Posts
    2

    Validation list from Mac Excel 2011 fails to function on Windows 7 Excel 2010

    I created a worksheet on my Mac using Excel 2011. It contains numerous basic formulas (all around for years and years) that allow us to evaluate the cost of products based on 20 or so variables. Each of the "input cells" is protected using a "validation list" to ensure that only the correct range of inputs can be used.
    The "validation look-up lists" are on the same worksheet as the calculations and data inputs. (Way off to the right).
    The entire worksheet / workbook is protected so that only the unlocked cells can be accessed, and then only via the drop down validation list.

    To ensure that my partners in various corners of the world (5 of us) can all access it with our platforms I saved it as an Excel 97-2004 .xls file.
    Works fine on my Mac - Mountain Lion with Excel 2011, Works on my Dell with XP & 2010 (my test platform).
    My partner in Florida however is running Windows 7 with Excel 2010. On his platform, when he clicks on what should be an input cell, he does not get the arrows for the validation list. Instead he can type numbers directly into the cell.
    I have sent him a new copy in 2011. It asked him to download some upgrade (???) so it could read the 2011 .xlsx file, then proceeded to act in the same fashion - no drop down lists.
    We looked over to the right and the validation lists are there.
    He is completely non-technical, this all happens as if by magic to him, so getting him to analyze the formulas, lists, cell links.... is a non starter.
    Does anyone have any idea why the validation function would not work across the different operating systems?

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

    Re: Validation list from Mac Excel 2011 fails to function on Windows 7 Excel 2010

    how is the data validation set up-does it use fixed cell references?
    Josie

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

  3. #3
    Registered User
    Join Date
    12-14-2012
    Location
    Kamloops, BC, Canada
    MS-Off Ver
    Excel 2011
    Posts
    2

    Re: Validation list from Mac Excel 2011 fails to function on Windows 7 Excel 2010

    The cell references are fixed as a list lookup function I.E. =$AK$14:$AK$107

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

    Re: Validation list from Mac Excel 2011 fails to function on Windows 7 Excel 2010

    can you post a copy with any sensitive information removed?

    also do you know which version of 2010 he is using? starter edition maybe?

+ 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