Hi,
I am having problems with my validation list when I have updated the
source data for my validation list.

Example:
In [A4, A8] I have a list of 5 book-titles (e.g. A4 = "TrueStory").
In [G4, ...] I have a dropdown list which uses the data in [A4, A8] to
select from.
I then choose "TrueStory" in G4, before I later alter A4 to
"SadStory". However, the edit in A4 does not have any effect on G4.
Why? And is it possible to make G4 automatically changed according to
A4?

The list is updated, which actually means that "TrueStory" now is not
allowed according to the validation list...

This is the example I followed to create my list:
http://cyberskillsguide.com/11/setti...in-excel-2007/

Hope you know how to fix this.
Thanks in advance...