Solved

2010 data validation not present in 03 and 07 excel versions

Posted on 2013-02-07
7
174 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 168 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 166 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
SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

 
LVL 26

Assisted Solution

by:redmondb
redmondb earned 166 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:broomee9
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

Ready to get started with anonymous questions?

It's easy! Check out this step-by-step guide for asking an anonymous question on Experts Exchange.

Question has a verified solution.

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

This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

623 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