Hello,
I am new to the forums and also new to the finer functions of Excel. I began working in 97-03, but have recently received an upgrade from my employer to 2010.
I really love 2010! However I have an issue with saving files to earlier versions and retaining the drop-down lists I need when distributiong workbooks around the office to members WITHOUT upgrades.
Any tips on how this can be done ( if at all ) ?
Thanks!
~direWOLV
If you want compatibility, either develop the workbook in 97/03 and save as .xls or .xlsx, or use functionality that is available in the early versions.
Where is the source for the drop down list(s)? Have you defined a named range for it?
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
A coworker suggested somthing similar! Currently my source data is on a seperate worksheet. I am in the process of shifting everything to the same work sheet and just hiding the data. Hoepfully that will work!
Thanks for the help
~direWOLV
You don't need to do that. Just name the range, for example, ListData. Then, in your Data Validation, use:
=ListData
Regards, TMS
Thanks for the rep. Is this solved?
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Or you can use this way:
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks