Hi All

I have a workbook containing multiple charts. Every chart links to a hidden sheet. On the hidden sheets I defined dynamic named ranges. The named ranges and a cell link are then used to populate combo boxes on the charts, so that I can specify various teams or business units and compare their performance. The workbook was developed in Excel 2010 (PC). Some users in our organization use Excel for the Mac 2011. When emailed, most (but not all) of the combo boxes have vanished from the charts. Presumably they are still there somewhere but hidden. I then saved the workbook on a Mac, re-opened it and set up the combo-boxes again on the charts using Excel for the Mac 2011. When emailed to Mac users, these vanished, but were visible when opened again on the Excel 2010 for the PC.

I have been unable to find any help online that deals specifically with this issue, so any insights would be appreciated.

Cheers

Ken