+ Reply to Thread
Results 1 to 2 of 2

Data Validation settings disappear

Hybrid View

  1. #1
    Registered User
    Join Date
    02-14-2014
    Location
    Macomb, MI
    MS-Off Ver
    Excel 2010/2007
    Posts
    1

    Data Validation settings disappear

    Good afternoon,

    I created a workbook in Excel 2010 which uses data validation settings referencing ranges on different worksheets. When my users open the workbook in Excel 2007, the data validation settings which reference other worksheets are dropped. If I enter the exact same validation ranges directly into Excel 2007 they work fine. Can anyone explain why? My workbook contains a lot of data validation and it would be a royal pain to have to re-enter them all in Excel 2007.

    Thanks,
    Joe

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2504 Win 11
    Posts
    24,706

    Re: Data Validation settings disappear

    I have found that when doing DV on one sheet and the range of data is on another sheet, it always works better to assign a range name to the data and then in the DV set up, you can then choose the range, ie. =MyRange.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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. Data Validation Disappear in New Location after Running Advance Filter
    By Collinn in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-30-2012, 12:50 AM
  2. [SOLVED] DATA/VALIDATION/SETTINGS
    By DATA/VALIDATION/SETTINGS in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 07:05 PM
  3. [SOLVED] DATA/VALIDATION/SETTINGS
    By DATA/VALIDATION/SETTINGS in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 04:05 AM
  4. DATA/VALIDATION/SETTINGS
    By DATA/VALIDATION/SETTINGS in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 PM
  5. DATA/VALIDATION/SETTINGS
    By DATA/VALIDATION/SETTINGS in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-12-2005, 10:05 AM

Tags for this Thread

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