How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Jess M. Your Own Question

Jess M.
Jess M., Computer Support Specialist
Category: Microsoft Office
Satisfied Customers: 4045
Experience:  Computer Software Specialist for more than 10 years
Type Your Microsoft Office Question Here...
Jess M. is online now
A new question is answered every 9 seconds

I have a template that was created for dropdowns. I have some

Resolved Question:

I have a template that was created for dropdowns. I have some vendors that can not open the dropdowns or see them, except on windows xp. How can this sheet be converted to show the drop downs for everone?
Submitted: 9 months ago.
Category: Microsoft Office
Expert:  Jess M. replied 9 months ago.
Hi, welcome and thank you for your question. My name is XXXXX XXXXX X am glad to assist you today.

Are you referring to an MS Excel template? What version was this template created? What version of Excel are you using now?


Please let me know so that I can help you further.

Best regards,
Jess
Customer: replied 9 months ago.

I would like to send you the template. I am not sure what system was used to create it, but 2 of my 12 vendors could not see the drop downs, and I need everybody to be able to see and use.


 


How can I send you the actual template?

Expert:  Jess M. replied 9 months ago.
Hi Janice,

Thank you for writing back. In order to send me a copy of the template, please go to http://wikisend.com then upload the template file there. No need to register to wikisend, just upload the file then wait for the screen to show the 6-digit file ID. Post the ID or the download link when you reply so that I can download your file.

Jess
Customer: replied 9 months ago.

http://wikisend.com/download/260720/Jewelry Template 6-20-13.xlsx

Expert:  Jess M. replied 9 months ago.
Janice,

I got the file. Are you saying that people with Windows 7 mostly don't get the dropdowns in your template?

Jess
Customer: replied 9 months ago.

yes, and I don't understand, because I have 7 home addition and I can see them.

Expert:  Jess M. replied 9 months ago.
Alright, please give me a moment while I give you the procedures to correct the problem. One moment please.

Jess
Customer: replied 9 months ago.

ok

Expert:  Jess M. replied 9 months ago.
Janice,

I have Excel 2007 and 2010 here. The Data Validation that controls the display of these drop down arrows are working in my Excel 2010 but not in 2007.

Are the people having problems with your template those using Excel 2007 also? I am checking the compatibility issue here. I will keep you posted.

Jess
Customer: replied 9 months ago.

They probably are using 2007.

Expert:  Jess M. replied 9 months ago.
Janice,

This is indeed a known problem with Data Validation across Excel versions. That is, if you created the file in Excel 2010 with Data Validation, then this data validation will only work flawlessly with Excel 2010. It won't work with Excel 2007 and other versions.

There are two (2) options for you here. First is to re-create the template doing it in Excel 2007 and allow people with Excel 2007 to use it. The second option is to name the ranges of your data source.

Please give me a moment while I do the second option for you. I will give you back the modified Excel template.

Jess
Customer: replied 9 months ago.

you mean you will send back the template and it will work for all?

Expert:  Jess M. replied 9 months ago.
Yes. I am re-doing it now since it now (just copying to new sheets) since it is password XXXXX Please give me a moment. I will send the file that will work with Excel 2007 and 2010 and other versions.

Thanks,
Jess
Customer: replied 9 months ago.

Thanks

Expert:  Jess M. replied 9 months ago.
Janice,

It's done. The file can be downloaded here:
http://wikisend.com/download/237842/Jewelry_Caption_rev1.xlsx

I recreated the file but I copied and pasted the data. What I then did was to NAME the ranges of the data in the DATA tab. For instance, please select the range A3:A4 in the DATA tab, it will show the name Cat there. I made a name for all columns then recreated the Data Validation. When selecting the range in the Data tab, the formula is automatically using the NAME of the range.

I have tested it and it now works on 2007 and 2010 Excel.

Please remember to rate my service positively (3-5 stars/faces) if this helped. Tips are always highly appreciated! Cool

If you have any other questions, please ask me or reply to me – I’ll be happy to respond.

Thank you!

Best regards,
Jess
Customer: replied 9 months ago.

Can I just click on this link and save this document? I would like to send it to my vendor who could not use it, and get back to the rating?

Expert:  Jess M. replied 9 months ago.
Janice,

Yes, please download the file from the link I gave you. I did not protect that file. Please protect it the way you do with your Excel file, then send it to your people.

It will surely work. I tested that in my Excel 2007 and 2010 and 2003 Cool Yes, you can rate my answer any time.

Please remember to rate my service positively (3-5 stars/faces) if this helped. Tips are always highly appreciated! Cool

If you have any other questions, please ask me or reply to me – I’ll be happy to respond.

Thank you!

Best regards,
Jess
Jess M., Computer Support Specialist
Category: Microsoft Office
Satisfied Customers: 4045
Experience: Computer Software Specialist for more than 10 years
Jess M. and 6 other Microsoft Office Specialists are ready to help you

JustAnswer in the News:

 
 
 
Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.
 
 
 

What Customers are Saying:

 
 
 
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
< Last | Next >
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
  • This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex Los Angeles, CA
  • Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP Hesperia, CA
  • I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin Kernersville, NC
  • Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther Woodstock, NY
  • Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know. Robin Elkton, Maryland
 
 
 

Meet The Experts:

 
 
 
  • jstinehelfer's Avatar

    jstinehelfer

    Information Systems Manager

    Satisfied Customers:

    36
    A+ Comptia Certified computer repair
< Last | Next >
  • http://ww2.justanswer.com/uploads/JS/jstinehelfer/2012-6-6_215146_Pictureofme1.64x64.png jstinehelfer's Avatar

    jstinehelfer

    Information Systems Manager

    Satisfied Customers:

    36
    A+ Comptia Certified computer repair
  • http://ww2.justanswer.com/uploads/JA/JasonJames122/2011-12-16_135647_jasonjamesheadshotweb.64x64.jpg JasonJames122's Avatar

    JasonJames122

    Computer Enthusiast

    Satisfied Customers:

    0
    I manage all information systems (network of Windows PC's and servers with Microsoft Office products) for a small business
  • http://ww2.justanswer.com/uploads/JE/jessmagz/2012-6-6_18129_jm.64x64.jpg Jess M.'s Avatar

    Jess M.

    Computer Support Specialist

    Satisfied Customers:

    270
    Computer Software Specialist for more than 10 years
  • http://ww2.justanswer.com/uploads/CH/chutz747/2011-11-6_14231_me.64x64.jpg The-PC-Guy's Avatar

    The-PC-Guy

    Computer Manager

    Satisfied Customers:

    260
    20 years experience providing remote computer support
  • http://ww2.justanswer.com/uploads/SE/Seashore2011/2011-12-6_33418_111205223015.64x64.jpg Chris L.'s Avatar

    Chris L.

    Support Specialist

    Satisfied Customers:

    120
    Certified Expert with over 10 years experience.
  • http://ww2.justanswer.com/uploads/SP/spherrod/2012-6-6_174244_1000852.64x64.JPG Steve Herrod's Avatar

    Steve Herrod

    Computer Support Specialist

    Satisfied Customers:

    116
    Trained in Microsoft Office from 2000 through to latest version 2010.
  • http://ww2.justanswer.com/uploads/KR/krkljatorm/2012-6-24_153417_ITMiro.64x64.jpg IT Miro's Avatar

    IT Miro

    Computer Scientist

    Satisfied Customers:

    94
    Bachelor's Degree in Information Technology, Microsoft Certified Professional