Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

2010 data validation not present in 03 and 07 excel versions

Posted on 2013-02-07
7
Medium Priority
?
182 Views
Last Modified: 2013-12-14
I have created a spreadsheet for customers with a summary sheet and a dedicated sheet for each customer. The last sheet has all the data vaildation lists. I have named each list and linked the name in each relevant cell on the customer sheets eg. =Practice.

Customers are still telling me that no drop down lists are appearing. they are using a mix of 97-03 and 2007 excel versions.

Any help much appreciated.

Sean
0
Comment
Question by:Seancsn
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 52

Expert Comment

by:Rgonzo1971
ID: 38863571
0
 
LVL 24

Accepted Solution

by:
Steve earned 672 total points
ID: 38863580
You cannot have the list on another sheet in previous versions of Excel.

If you move the validation list to the same sheet, or hard code it, the list should work.
0
 
LVL 16

Assisted Solution

by:terencino
terencino earned 664 total points
ID: 38863597
Can you send a screenshot of the data validation dialog? Some of the earlier versions of Excel had issues with off-sheet validation ranges, and rgonzo has a good point. Microsoft issued an instruction to help with that.

Using a validation list in another worksheet or workbook

...Terry
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 26

Assisted Solution

by:redmondb
redmondb earned 664 total points
ID: 38863800
Hi, Seancsn.

Excel 2010 introduced a new Data Validation attribute ("<x14:dataValidations>") which doesn't play nicely with earlier versions of Excel. In my experience so far, using Names has sorted out this issue, but obviously not in your case.

Assuming that the data in the file is sensitive, could you please post a redacted copy here - a single customer sheet and the summary sheet with a single list is fine - as long as the file is showing the same problem.

BTW, is it possible that the Data Validations didn't originally use Names?

Thanks,
Brian.
0
 

Author Comment

by:Seancsn
ID: 38869881
Thanks everyone. For some reason the Names set up is now working on the systems.
0
 
LVL 24

Expert Comment

by:Tracy
ID: 39718538
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

Enroll in September's Course of the Month

This month’s featured course covers 16 hours of training in installation, management, and deployment of VMware vSphere virtualization environments. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question