Excel - Drop down menu

How do you edit a drop down menu's location?
--
Thanks,
George

  Max replied to George

One guess as to the root Q here. Use named ranges as DV sources for better
flexibility. Then you can set the DV up easily to work across sheets as well.
Any joy? hit YES below
--
Max
Singapore
---

  Gord Dibben replied to George

Location of the dropdown or location of the list range for the dropdown?

Cut and paste should get you the first.

In DV>List>Source dialog you should be able to change the list range.


Gord Dibben  MS Excel MVP

Excel Win7 VirtualStore Weirdness with Excel 2002 and earlier I thought I'd share a weird experience I had today in installer for it - - which registers it as an add-in for all installed versions of Excel - - and tested it. Fine in Windows 2000 in all installed versions of Excel. Boot to Windows XP, fine there too. Boot to Windows 7. Fine in Excel 2010, 2007, and 2003. But Excel 2002 and 2000 were still loading the old version of the add-in. I uninstalled the add-in, made sure it was gone, and reinstalled it. Same problem in Excel 2002 and earlier; still works fine in Excel 2003 and later. I opened the VB editor in Excel 2003 and in Excel 2002

Excel IRM Permission Disappeared in .xls file Hello, I have a very important .xls file (created in Excel 2003) that I had protected using my MS Passport account with IRM. I have opened it many times in the past in both Excel 2003 and 2007. Now, when I try to open it, I am told that I and could you open the edit permission window again to check the permission? http: / / office.microsoft.com / en-us / word / HA101029181033.aspx For this kind of issue, we may have little troubleshooting steps on Excel application end, you may contact IRM / RMS engineer to check if there is a way you for your understanding, hope the issue can be figured out soon. Regards, Daisy Cao Microsoft Online Support Microsoft Global Technical Support Center = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = When responding to posts, please "Reply to Group" via your newsreader 19:16:41 -0500 | Lines: 14 | X-Priority: 3 | X-MSMail-Priority: Normal | X-Newsreader: Microsoft Outlook Express 6.00.2900.5843 | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900

Excel Aggiornamento - Microsoft Risponde all’evoluzione delle Community Cosa accade? Per informarvi che Microsoft comincerà presto a chiudere I newsgroup e a “transitare”, pian piano, se lo vorrete, il traffico sui Forum Microsoft. Perchè? Come ben sapete, i newsgroup sono esistiti per molti anni; il problema però è newsgroup. E’ possibile trovare informazioni su come installare e configurare il bridge qui: http: / / connect.microsoft.com / MicrosoftForums / Perchè i newsgroup verranno chiusi? Tutti i newsgroup pubblici verranno chiusi tra il la chiusura dei newsgroup, dove posso andare online per continuare le discussioni e ricevere supporto? Microsoft vi fornisce un’ampia scelta di forum, alcuni dei quali coprono lo stesso argomento od ottimale per continuare le discussioni online. Raccomandiamo quindi di cominciare con il http: / / social.answers.microsoft.com / Forums / it-IT / officeexcelit forum Vi invitiamo comunque a visitare i Forum Microsoft: http: / / www.microsoft.com / communities / forums / default.mspx Se ho domande, chi devo contattare? Se

Excel Où_est_passé_mon_newsgroup_? Bonjour le monde, Excusez moi de poser ma question ici, mais comme elle concerne quand m??me Excel j'ose oser. Voil??: il y a peu je trouvais tous les sujets pos??s ici pour Excel avec un lien comme ??a: http: / / www;microsoft.com / france / communa. . . . default.mspx?dg microsoft.public.fr.excel Depuis peu ??a ne marche plus (the page cannot be found 404 error) Par contre dig??s en fran??ais (y compris d'anciens miens) avec le lien http: / / www.microsoft.com / communities / newsgroups / list / en-us / default.aspx?query = sauvegarder&dg = microsoft.public.fr.excel&cat = fr_FR_26e1cbd5-1a29-4c80-8c95-fe265a9006f6〈fr&cr = FR&pt = &catlist = &dglist

Excel Erinnerung - Microsoft reagiert auf Evolution der Community Microsoft Office betrachtet Community als Teil des neuen Office 2010 Wie Sie wissen ist das Jahr 2010 ein wichtiges Jahr f?r Microsoft. Die neue Office-Version kommt auf den Markt. Office 2010 soll Ihnen das Leben und Hersteller beim Kauf eines neuen PCs erwerben. Ihre gew?nschte Version ist auch direkt von Microsoft erh?ltlich. Durch eine neue Methode zur Softwarebereitstellung mit dem Namen ?Click-To-Run? gelingt individuell! Worum geht es? Diese Nachricht dient dem Zweck, Sie dar?ber zu informieren, dass Microsoft demn?chst die Newsgroups abstellen und die Nutzer auf die Microsoft Foren verweisen wird. Warum? Wie Sie vielleicht wissen, gibt es Newsgroups schon seit einigen Jahren doch ist die Nutzung der Microsoft Newsgroups seit Jahren stetig zur?ckgegangen, da Kunden und Teilnehmer vermehrt L?sungen in den