+ Reply to Thread
Results 1 to 2 of 2

Data Validation Changes Source on its own

  1. #1
    Registered User
    Join Date
    08-03-2024
    Location
    Zambia
    MS-Off Ver
    2021
    Posts
    5

    Data Validation Changes Source on its own

    I do not use VBA so I wouldn't expect this to be the cause of the problem. My spreadsheet is locked so no one else has the ability to make changes. I use data validation to create a drop down list using cells on a different sheet in the same workbook. I set the data validation info, save the file, and it's working perfectly but when i send the file to my workmate the data validation source has changed to the same range of cells but on the sheet that the drop down box is on instead of the sheet where the info was selected. When he re-sends me the file and i open the received file it's seen that the source data on the data validation has indeed changed. Where must i be going wrong?

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    26,936

    Re: Data Validation Changes Source on its own

    Welcome to the Forum sm4nch3z!

    It's hard to say what's happening without a more detailed description. The best way to help is for you attach the file here for us to examine. If there is private data, remove it first. If the dropdown list itself contains private data, just replace it with something else. Tell us:

    What sheet/cell contains the data validation with list
    What sheet/range is the data for the list

    If you do not attach a file you must at a minimum answer the above questions and show us exactly the formula you used to set up the data validation list. Not what you intended to use, but an actual copy and paste of the formula.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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] Data Validation from multiple source
    By SMILE in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-31-2016, 06:59 AM
  2. [SOLVED] Data validation lists change source designation when list data is updated.
    By frenurks in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-28-2015, 06:52 AM
  3. Too much IF in Data Validation List Source
    By Afrikite in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-09-2014, 10:21 AM
  4. Data Validation - Source error
    By thedude1222 in forum Excel General
    Replies: 3
    Last Post: 09-13-2013, 09:51 PM
  5. [SOLVED] set data validation source list
    By rana_shaker in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-14-2012, 03:06 AM
  6. data validation-Can the source of the validation criteria be dfrom a different sheet?
    By yael pinkert in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-07-2009, 04:28 AM
  7. [SOLVED] Data Validation Source Box
    By Drahos in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-08-2005, 07:25 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