excel from PC to Mac... problems with drop down menus

[laurena613]

Version: 2008
Operating System: Mac OS X 10.4 (Tiger)
Processor: intel

I work for a large company and our finance dept. uses excel (on a PC) to create P.O.s. Then they send them to me and I have to select something from a drop down menu and email it back. HOWEVER, I can not use the drop down menu when I open her PC excel spreadsheet on my Mac. IS there a way to fix this? Does she need to upgrade her office version on her pc? can she save it out in a different way so that I can open it and the list function will work?

Help!

 

[Bob Greenblatt]

Version: 2008
Operating System: Mac OS X 10.4 (Tiger)
Processor: intel

I work for a large company and our finance dept. uses excel (on a PC) to
create P.O.s. Then they send them to me and I have to select something from a
drop down menu and email it back. HOWEVER, I can not use the drop down menu
when I open her PC excel spreadsheet on my Mac. IS there a way to fix this?
Does she need to upgrade her office version on her pc? can she save it out in
a different way so that I can open it and the list function will work?

Help!

Where is the drop down menu? Is it really a menu, or an in cell list. Was it
built with cell validation, or is it an object placed on the cell. If so, it
must be made using the forms tool bar. She needs to change the way in which
the PC worksheet works. She does not need to upgrade, or save in a different
format.

 

[laurena613]

it is a drop down menu that exists in one of the cells. it appears all jumbled when i open it on my mac. it is part of a database. How would that menu need to be created so that it works on both platforms?

 

[Bob Greenblatt]

it is a drop down menu that exists in one of the cells. it appears all jumbled
when i open it on my mac. it is part of a database. How would that menu need
to be created so that it works on both platforms?

So, it is data validation? How is it part of a database? An Excel database?
Where is the data? What does "all jumbled" mean?

 

[mjpstevens]

"

So, it is data validation? How is it part of a database? An Excel database?
Where is the data? What does "all jumbled" mean?

We have a similar problem with a workbook that was created on a PC. It
worked in Excel from office 2004 for the mac, but the lists do not work in
excel from office 2008 for mac.

What I have found is that the lists are truncated after the 65th entry on
the list. It doesn't mean that there are always 65 entries in the list, it
truncates after the 65th entry in the source. So if I have created a name
which uses data from a different worksheet in the same workbook which uses
items 5-79, it truncates the list of available items on the mac at the 65th
data entry. If I choose it to be the range 10-79 it truncates at exactly the
same place.

This happens with multiple lists all at the 65th entry, so I find it hard to
believe that there is a hidden character, or some other unique thing about
that line in the data. I even tried deleting some lines and it then
truncates at the new 65th line.

I have also tried creating a new workbook on the mac, and copying data to
the new workbook from the old workbook. I still get truncation on the list.
However at new location of 72nd data slot.

Creating an entirely new workbook and creating everything from scratch with
relatively small fields in the data doesn't seem to have an issue. However,
any cutting and pasting from the previous workbook seems to make everything
crazy.

I have also noticed that if I move the data to the same worksheet the
truncation occurs at a different location as well. Changing the page
properties so that it all fits on one page also changes its behavior.

 

[Joe_LeBlanc]

mjpstevens,

Would it be possible for you to provide me with a file that has this behavior? If I understand correctly, you're only able to reproduce it with your file, or the data from that file, correct?

Thank you!

-joe leblanc
MacBu Excel team
(e-mail address removed)

 

[Jeremy Sparks]

Has there been any resolution to this issue. We too are facing it. We have a
program that extracts data from Quickbooks on a PC and creates timecards in
Excel that our Mac users are able to fill out. The Job descriptions are
entered by using an in cell drop down list. The list is only able to scroll
to about the 65th job or so and the Mac Excel 08 users are not able to see
any jobs below that. The list is pulled from a hidden worksheet in the excel
document. The Mac Office 2004 users have no issue as well as Windows office
2007, or 2003 users. All of our Mac office 2008 users are on the latest
version of mac os 10.5. Some of your office 2004 users are as well on os 10.5
others on 10.4. I can provide you with a sample of the data file if needed.

 

[Todd Aton]

I would like to take a look at the sample file. Please send it to
(e-mail address removed).

Todd Aton
Macintosh Business Unit
Microsoft Corporation

Microsoft makes no warranties, express, implied or statutory, as to the
information in this post.



On 6/26/08 9:19 AM, in article
(e-mail address removed), "Jeremy Sparks" <Jeremy