Excel 14.2.5 for Mac - Workbook saves in separate PDF even when Save Entire Workbook is selected. WHY?

[RahRah]

Hello,
I am new to this forum and after spending hours last nite using google to search for anyone else with this issue... I decided that this may be the BEST place to get my problem answered.
My printer drive is up to date as well as my excel software. When I try to save a workbook (5 sheets w/minimal information) as a PDF it saves each sheet in a separate PDF file instead of saving it in one 5page file. I've checked my preferences and unless I'm missing something... all is set to what it should be. Is anyone else having this problem? Is there a solution to this? I thank you in advance for your time/help.
Blessings, RahRah

 

[Ron de Bruin]

This is a bug in Excel for the Mac

I create some VBA examples as a workaround that you can use
VBA code in Excel 2011 for the Mac

 

[RahRah]

This is a bug in Excel for the Mac

I create some VBA examples as a workaround that you can use
VBA code in Excel 2011 for the Mac

Hi Ron,
Thanks so much. I will read through your examples and give it a try.
Thanks Again!