drop down list, does it work in Office 2003 and Office 2007

[Eat More Bacon]

https://app.box.com/s/h0hflar61zh6c96lrmq8bc92mjkcjdjp

Examine the drop down lists in column A. Why do they fail when they are opened in Office 2003?

 

[Debaser]

Because you cannot directly refer to a range on another sheet in a DV formula in those versions. You need to name the range you want to use as the source, then use that range name in the DV formula.

 

[Eat More Bacon]

Thanks