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
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
It's been some time since we worked on this. Need to pull the file and review it again...
Will get back to you
Ok I want to know what exactly the problem is in that file? Please specify one of the cells that has that issue
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
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
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
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
Jerry, could you elaborate a little, i.e. please address the part of my question that you said ok to
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
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)
Opting Out. Good bye