Excel 2007 dropdown error in excel 2010

Closed
Ann - 9 Mar 2011 à 01:43
 Ann - 18 Mar 2011 à 03:46
Hello,

In excel 2007, I used Data validation list (drop down list) which retrieved data from another sheet and it works fine in excel 2007.
However, once I open with excel 2010 the same sheet(without changing anything), the drop down list contents are vary.

For example,

I retrieve data from another sheet called 'Month'

=Month!A1:A5 in excel 2007

when I open in excel 2010, this drop down list valued auto changed to
=Month!A4:A8

I would like to know how to fix that. Thanks in advance.
Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
9 Mar 2011 à 08:18
I dont have office 2010, so cant really tell you why would it happen so. But what if you dont use relative ref. but rather use absolute like
=Month!$A$1:$A$5
Hi Rizvisa1,

Thanks a lot for your help. I tried with relative ref, it works in excel 2010.
Thanks.

Ann