Mac OS Excel 08 behaving differently on Windows and Mac

eggman

eggman

Disciple
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?
 
Yes it does. You can see in the second Sheet, the data is there. Moreoever if you start from say 10,000 till 35323 it works.
 
I don't have a Mac either, but can you tell what happens when you enter A9:A35323 directly on Mac (you have given a split pre and post 10000, what about the full list if entered manually)

---------- Post added at 08:25 PM ---------- Previous post was at 08:17 PM ----------

Alternatively, just wondering if you have already tried using the name range (naming the list) and referring to the list instead of the cell range
 
Back
Top