Saving in Excel 2010 for 2007

[mehbodo]

I have recently made a Excel file with a dropdown menu using data validation list which dynamicly links to another sheet. I then have cells that link to the dropdown cell using the HLOOKUP command. Everything work great in Excel 2010 but when I send the file to a colleauge who is using excel 2007 the dropdown box doesnt work, does anyone know how to fix this?

 

[Norie]

How did you create the dropdown/data validation and how is it not working for your colleague?

As far as I know there aren't any differences between 2007 and 2010 that could cause problems with that sort of thing.

 

[mehbodo]

Oh of course, In 2007 the drop down box doesnt work. I didnt think there was a difference either. I created the box with a data validation list linking to =Data!$B$1:$S$1

 

[mehbodo]

...as far as i can tell it has changed the dropdown box back to plain cell in '07

 

[mehbodo]

For some reason in '07 it won't let me choose the data validation list source from a different worksheet...

 

[mehbodo]

nevermind, I named the range of cells and linked to it that way, working now.