Excel 2007 dropdown error in excel 2010

Ann - Mar 9, 2011 at 01:43 AM
 Ann - Mar 18, 2011 at 03:46 AM

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

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

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 9, 2011 at 08:18 AM
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
Hi Rizvisa1,

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