Hello,
I've set up a template in an Excel 2010 document on my Microsoft PC. The file uses drop downs using the data validation function.
The problem I'm having is that I've sent the file to a colleague whom only uses a Mac with Microsoft 2008 and the drop downs aren't functioning.
I've tried tweaking the file by only using the data validation source on the same sheet (rather than on a different tab) and i've tried saving in an older format i.e. 1997-2003 but the drop downs still arent working.
As I dont have a Mac with Microsoft 2008 I'm really struggling to know where to start to fix this - I do have a Mac with 2010 and it does work!! Can anyone offer any suggestions?
Many thanks
Bookmarks