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 John D Your Own Question

John D
John D, BS Degree in Engineering
Category: Mac
Satisfied Customers: 9658
Experience:  Worked on Macs and PC's for 20+ years.
53785
Type Your Mac Question Here...
John D is online now
A new question is answered every 9 seconds

Im using excel for Mac and when I open a worksheet that has

Customer Question

I'm using excel for Mac and when I open a worksheet that has multiple drop down boxes, (that work on other peoples macs) I only have one that works and the rest appear as empty cells? It must be a setting, can you help?
Submitted: 2 years ago.
Category: Mac
Expert:  John D replied 2 years ago.

Hi,


I will be happy to help you with this. Do you have the file available that you could send

 

Here is how to send the file:

 

Go to http://www.wikisend.com/ and upload the file (no need to signup) then copy the "File ID" number (or the download link) that you will be given and paste it here in your reply.

 

If the file has sensitive information let me know before you upload it

Customer: replied 2 years ago.
http://wikisend.com/download/501342/Calculator.xlsx

The yellow boxes all should have pull down menus.
Expert:  John D replied 2 years ago.

Ok the only yellow cell that has a drop down list is cell G5. The others are all empty, possibly due to file corruption

 

I can repair the file and get the others to work but I need to source data for each drop down list

 

Also need the password XXXXX unprotect the sheet

 

 

Customer: replied 2 years ago.
John, It can't be a corrupt file because it works on other people systems just fine. It seems to be an issue with my laptop specifically. I'm guessing it might be an Excel setting???
Expert:  John D replied 2 years ago.

It's been some time since we worked on this. Need to pull the file and review it again...

 

Will get back to you

 

 

 

 

Expert:  John D replied 2 years ago.

Ok I want to know what exactly the problem is in that file? Please specify one of the cells that has that issue

 

 

Customer: replied 2 years ago.
any cell that is highlighted in yellow that does not have a pull down as part of it. They may all work fine on your end as it works on other computers here in our offices. On my computer the only cell that has a pulldown is the one that has the package name of Platinum, Gold, or Silver???

Jerry
Expert:  John D replied 2 years ago.

No Jerry as I told you I do not see any drop down lists in this file, except one

 

This same file will not have these drop down on any computer. You must be referring to another version of the file which is still intact

 

 

 

 

Customer: replied 2 years ago.
John,

I've re-uploaded the file. I only have one pull down when I open, however when I sent this same file to my secretary, she has pull downs on ALL yellow highlighted boxes?

Jerry

http://wikisend.com/download/239702/Retro Calculator Final.xlsx
Expert:  John D replied 2 years ago.

Jerry you are sending me the same file which is corrupted. Could you ask the secretary to upload her file and send you the download link so you can in turn pass it on to me

 

 

Customer: replied 2 years ago.
John,

Respectfully, XXXXX XXXXX hearing me. The file I sent you is the exact same file I sent to my secretary. I personally went to her desk, opend the file, and saw all of the drop downs. It seems to me this is a setting issue in excell that both your computer as well as my computer have in common. If you'd like, send me you email, and I'll have her forward you the exact email I sent her with the exact same file where she sees all of the drop downs.

Please advise.

Jerry
Expert:  John D replied 2 years ago.

Jerry I understand what you are saying but I need the file that she is using despite the fact it is the same file that you have sent her. Let her upload that file and send us the link

 

No we cannot use email here

 

 

 

Customer: replied 2 years ago.
OK, per your instuction I asked my assistant to upload the file from her computer. please find the link below.

Regards,

Jerry

http://wikisend.com/download/308848/Retro
Expert:  John D replied 2 years ago.

Thanks

 

Still the only drop down is in G5. However it is not computer related or an Excel setting issue, otherwise you will not see ANY drop downs

 

The file needs to be repaired. I can fix all the drop downs and guarantee that it will work on any system as shown in this sample file where G8 drop down has been reinstated. You should be able to see the drop down in G8

 

http://wikisend.com/download/255682/Retro%20Calculator%20Final.NEW.xlsx

 

 

 

 

Customer: replied 2 years ago.
OK, the password XXXXX the spreadsheet is ABN12345

Thanks,

Jerry

Expert:  John D replied 2 years ago.

Jerry, could you elaborate a little, i.e. please address the part of my question that you said ok to

 

 

Customer: replied 2 years ago.
Sorry John, I thought based on your last comment that you were going to repair the file and needed the password XXXXX do so? I said ok to you repairing it.

Jerry
Expert:  John D replied 2 years ago.

hmm...no that was not what I asked for in my last message.

 

Were you able to see the drop down in G8. If so I need the source data for the other drop downs so I can repair the file and set up the new drop downs

 

 

Customer: replied 2 years ago.
John,

I've sent you the password XXXXX you can access each sheet. All of the source data is on one of the sheets in the workbook you already have.

Thanks,

Jerry
Customer: replied 2 years ago.
By the way, YES is the answer to you question, I could see the drop down in G8
Expert:  John D replied 2 years ago.

Ok that confirms that the original file got corrupted. As said I can rebuild it for you if you can give me the source data for each drop down.

 

However, if you do not wish to do that (I am still prepared to continue helping you with) (Edited by Moderator)

 

Thank you

 

John D, BS Degree in Engineering
Category: Mac
Satisfied Customers: 9658
Experience: Worked on Macs and PC's for 20+ years.
John D and 2 other Mac Specialists are ready to help you
Customer: replied 2 years ago.
John, I disagree and don't accept your answer. The same file that you have shows dropdown boxes for all of the yellow-highlighted areas on ALL other computers in my office! It's only on my computer and I guess yours that it's not working on? If the file were corrupt as you've stated it would be corrupt on other peoples computers as well would it not? I'd like a sound resolution and then I am happy to assept and move on. I assure you I'm more frustrated with this than you are.

Jerry
Expert:  John D replied 2 years ago.

Opting Out. Good bye

 

Customer: replied 2 years ago.
Relist: Inaccurate answer.
Guy was arrogant and did not have the correct answer. Additionally he asked me to accept his answer prior to me getting the resolution to my issue.
Expert:  Freddy M. replied 2 years ago.
I sincerely XXXXX XXXXX the previous expert. You mentioned it works on other peoples mac's are they using the same version of excel as you (or an older version for example)? Also if you don't want to continue let me know as well so I can have this closed for you.
Customer: replied 2 years ago.
Dimmusacio,

I knew the last guy was an idiott!!! I was on a different version of Excel. I have now upgraded to the latest version as it work fine. I should charge the other guy for my time. Anyway, thank you and I'll be accepting your answer with my thanks!!!

Jerry
Expert:  Freddy M. replied 2 years ago.
You actually accepted the other expert but I will have it transferred thank you for the accept it is greatly appreciated. I also sincerely XXXXX XXXXX the other expert if you need our help again you can always get me by requestiong dimmusacio.
Customer: replied 2 years ago.
Thnaks, you'll be the only one I request!

Jerry
Expert:  Freddy M. replied 2 years ago.
Your welcome

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:

 
 
 
  • Hi John, Thank you for your expertise and, more important, for your kindness because they make me, almost, look forward to my next computer problem. After the next problem comes, I'll be delighted to correspond again with you. I'm told that I excel at programing. But system administration has never been one of my talents. So it's great to have an expert to rely on when the computer decides to stump me. God bless, Bill Bill M. Schenectady, New York
< Last | Next >
  • Hi John, Thank you for your expertise and, more important, for your kindness because they make me, almost, look forward to my next computer problem. After the next problem comes, I'll be delighted to correspond again with you. I'm told that I excel at programing. But system administration has never been one of my talents. So it's great to have an expert to rely on when the computer decides to stump me. God bless, Bill Bill M. Schenectady, New York
  • The Expert answered my Mac question and was patient. He answered in a thorough and timely manner, keeping the response on a level that could understand. Thank you! Frank Canada
  • 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
 
 
 

Meet The Experts:

 
 
 
  • Mike

    Mac Medic

    Satisfied Customers:

    6256
    Over 20 years IT experience with Apple computers in publishing, marketing and design.
< Last | Next >
  • http://ww2.justanswer.com/uploads/macthelife/2009-10-20_1899_mikesebaharsquare64.jpg Mike's Avatar

    Mike

    Mac Medic

    Satisfied Customers:

    6256
    Over 20 years IT experience with Apple computers in publishing, marketing and design.
  • http://ww2.justanswer.com/uploads/AS/ashiknasameen/2012-5-15_141836_final2.64x64.jpg Ashik's Avatar

    Ashik

    Mac Helper

    Satisfied Customers:

    5282
    7+ Years of Experience in troubleshooting Macs, iPhone, iPad, iPod etc
  • http://ww2.justanswer.com/uploads/DP/dpean/2012-6-6_172828_avatorme1.64x64.JPG Daniel's Avatar

    Daniel

    Mac Genius

    Satisfied Customers:

    4670
    Apple certified on desktop and portable, help desk qualified. Have owned and used Macs since 1989.
  • http://ww2.justanswer.com/uploads/VI/vinodvmenon2005/1.64x64.jpg Vinod Menon's Avatar

    Vinod Menon

    Support Specialist

    Satisfied Customers:

    2068
    worked as a Tech support Associate for Apple products
  • http://ww2.justanswer.com/uploads/BE/beboo/2011-1-14_201648_n5063313142021801763.64x64.jpg Brandon M.'s Avatar

    Brandon M.

    Mac Support Specialist

    Satisfied Customers:

    1501
    10+ Years Mac Support as contractor and currently an IT Manager for law firm
  • http://ww2.justanswer.com/uploads/MA/MacDruid/IMG_0232.64x64.JPG John T. F.'s Avatar

    John T. F.

    Mac Druid

    Satisfied Customers:

    1408
    20+ years in the computer/Mac industry
  • http://ww2.justanswer.com/uploads/MA/MacHelpdesk/1d2d506.64x64.jpg David's Avatar

    David

    Mac Support Specialist

    Satisfied Customers:

    1236
    BSc, H.Dip, Apple Certified