Drop down list excel not working

• Installation probably got corrupted on his machine some how since it works for you.

  Go into Add/Remove Programs, find Office and click "Change", then select Repair after it loads and let it go. That will probably take care of it.

• What kind of dropdowns are we talking about? If they're populated using a macro he may have a buried security setting that is preventing macros from running on all files by default with no prompt.
  

• Attached some screen shots with the boxes dropped on my computer. Remember his wont do that. 

  Thanks,

  Travis
  

  attach_file Attachment Screenshot.docx 60.2 KB

• Repairing Microsoft Office had no effect.

  Thanks,

  Travis
  

• Running Excel as an administrator hasnt helped either.

  Travis
  

• Just thought I would let everyone know that I found the issue is actually with a Microsoft Update. I found this article here.

  http://answers.microsoft.com/en-us/office/forum/office_2010-excel/kb2553154-breaks-com-and-active-x-...

  I hope this helps someone else in the future.

  Travis
  

  
  Spice (1) flagReport
  Was this post helpful? thumb_up thumb_down

• Thanks for the heads up. We still have a few users with '10.
  

  Spice (1) flagReport

  Was this post helpful? thumb_up thumb_down

What did Pito Salas invent?

Click here to reveal answer

Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

1. 09-22-2017, 08:17 AM #1

   Hi, I have a drop down list which is auto updating from a table. It works fine when the source data and drop down list are on the same sheet, but its not updating when the source data and drop down list are on different sheets What am I missing? Thanks

   Kevin

2. 09-22-2017, 08:21 AM #2

   if you copied it over, when you look at the format control the input range has to change to reference the original sheet, otherwise it will simply reference the new sheet range.

   Make contributors happy, click on the "* Add Reputation" as a way to say thank you.

   

   
   Sam Capricci

3. 09-22-2017, 04:32 PM #3

   Hi Sam, Thank you for looking, that does not appear to be the issue? its references the correct sheet i have just tried again in a new workbook and the same problem exists? Thanks

   Kevin

4. 09-23-2017, 04:32 AM #4

   Hi Excelski. Save the drop down list as a "Named Range" and the list will then be available to all sheets without having to reference the sheet name/number in any formulas or Data Validation (lists). Regards

   peterrc

5. 09-23-2017, 05:50 AM #5

   Hi Peterrc I have tried that too. I can create a drop down using a named range which updates as items are added to the list, but I can not do it with the data and the drop down on different sheets. I must be missing something simple? Thanks for looking

   Kevin

6. 09-23-2017, 07:06 AM #6

   is it just this particular workbook or is does it happen with other workbooks? Can you upload the workbook?

7. 09-23-2017, 10:19 AM #7

   its happening on all workbooks and on different excel versions, i must be doing something very basic wrong... repeatedly!!

   
   Attached Files
   • 
     Drop down.xlsx‎ (30.7 KB, 32 views) Download

8. 09-23-2017, 10:59 AM #8

   Hi Excelski, You had the Table Name as Nameslist and the Named Range as Nameslist. I've changed this (see attached) and it is now working. Please note I have used "=Names" in the Data Validation. Regards

   peterrc

   
   Attached Files
   • 
     Drop down PRC.xlsx‎ (9.4 KB, 55 views) Download

9. 09-23-2017, 01:54 PM #9

   Hi peterrc, I couldn't see the woods for the trees! Thank you Regards

   Kevin

10. 09-23-2017, 02:08 PM #10

    Hi Excelski, Happy to help! Regards

    peterrc