Results 1 to 4 of 4

Data Validation using list in another worksheet - works for all but one sheet!

Threaded View

  1. #1
    Registered User
    Join Date
    12-29-2008
    Location
    Phoenix, AZ, USA
    MS-Off Ver
    Excel 2003
    Posts
    2

    Unhappy Data Validation using list in another worksheet - works for all but one sheet!

    I am running into an odd issue and hope someone might be able to shed some light.

    I have created several lists on one sheet in a workbook and have assigned named ranges to each individual list. So far, so good.

    On various other worksheets, I have created Data Validation rules to allow users to select the relevant data from drop-down lists. (using formulas such as =List1, =List2, etc. in the Source box to capture the named ranges I had created).

    Everything works perfectly...EXCEPT for one worksheet, which continues to give me the error message, "You may not use references to other worksheets or workbooks for Data Validation criteria."

    Can anyone explain why this error would only occur on one worksheet and work fine for all the other sheets? I'm perplexed!

    Thanks for your help!
    Heather
    Last edited by GSumnerFan; 12-30-2008 at 12:37 PM.

Thread Information

Users Browsing this Thread

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

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