Hi Guys
I am developing an integration between Excel and a System Software. Basically the System software downloads data in Excel format, fills it and uploads it back and the DB is updated after the uploaded.
However I'm facing an issue. The Mac version of excel is not behaving properly however the Windows version is.
Here is my problem:
Download the following file and open in excel On a Mac:
Free Cloud Storage - MediaFire
My requirement:
To have a dropdown on sheet '11-JUL-2012' , cell E7 , which shows the data from sheet 'Drop_Down_Data' , cell A9 to A35323.
If you click on the cell E7(on first sheet) you can see there is an indicator for drop down , but there is no value loaded.
Now try this:
Select the cell, E7 and Go to Data->Validate .
Change '=Drop_Down_Data!$A$9:$A$35323' to '=Drop_Down_Data!$A$9:$A$10000' . Voila! The drop down works.
It basically is showing the data from Cell A9 to A10000. Now change it to '=Drop_Down_Data!$A$10000:$A$35323'. Again , the drop down works. So it is now showing the data from A10000 to A35323.
So it means there is no wrong data in the list, and I see no reason why the drop down is not working from line A9 to A35323.
Funny thing is, if you download the file and open it using Excel 07 in Windows, it will work perfectly.
Any idea why this behavior is so?
