List manager conversion from Excel 2003 for Windows

[Steve Knight]

We developed an Excel spreadsheet on a PC using Excel 2003 for Windows, the
spreadsheet uses list manager.

Our Macs (iMac G5, Office 2004 SP2) open the file with no problems using
Excel 2004 but the list manager functionality does not work.

Is there a solution?

 

[Bernard Rey]

Steve Knight a écrit :

We developed an Excel spreadsheet on a PC using Excel 2003 for Windows, the
spreadsheet uses list manager.

Our Macs (iMac G5, Office 2004 SP2) open the file with no problems using
Excel 2004 but the list manager functionality does not work.

Is there a solution?

What do you mean writing "does not work"? If you click on any cell in the
area that is part of the list and get the "List..." item from the "Insert"
menu, you'll turn the list manager back on. Does this answer the question?

It's true that in the Windows version, they changed location and placed it
in the "Data" menu. But it's about equivalent, so I guess it should be OK.

 

[DerekSn [MS]]

Hello Bernard, thanks for the posting.

The Mac Excel List manager and the Windows Excel Data List tool are
similar in concept, but distinct in how they are saved to the file and
managed. The data in the cells, as you've seen, is preserved
cross-platform, but the List Manager is not turned on for the range
that is using the Windows Excel List feature. So when you turn on the
List Manager for Mac Excel, you will have to set up your column
formatting and total row separately from the Windows List tool -- they
won't synch up. This is a corner of the Excel world where the Mac and
Windows versions have similar features but where the features are not
identical or conjoined between platforms.

-Derek
This posting is provided "AS IS" with no warranties, and confers no
rights.

 

[Steve Knight]

The Mac Excel List manager and the Windows Excel Data List tool are

similar in concept, but distinct in how they are saved to the file and
managed. The data in the cells, as you've seen, is preserved
cross-platform, but the List Manager is not turned on for the range
that is using the Windows Excel List feature. So when you turn on the
List Manager for Mac Excel, you will have to set up your column
formatting and total row separately from the Windows List tool -- they
won't synch up. This is a corner of the Excel world where the Mac and
Windows versions have similar features but where the features are not
identical or conjoined between platforms.

Many thanks, most helpful.

Steve