Drop Down List Not Updating Automatically

Hi,

I am trying to populate a drop down list in Excel based on the solution
proposed on the website

http://www.contextures.com/xlDataVal03.html

However, I find that the list only gets updated if I do a Ctrl S (save the
document).

Have any of you faced a similar problem before with excel drop down list?

If tyhe update happens only when you hit CTRL + S to save, this generally means
you are set to Manual Calculation.

Go to Tools>Options>Calculation and set the Automatic.


Gord Dibben MS Excel MVP

On Fri, 23 Jun 2006 10:15:03 -0700, RBan <[email protected]> wrote:

>Hi,
>
>I am trying to populate a drop down list in Excel based on the solution
>proposed on the website
>
>http://www.contextures.com/xlDataVal03.html
>
>However, I find that the list only gets updated if I do a Ctrl S (save the
>document).
>
>Have any of you faced a similar problem before with excel drop down list?