OK, so installing the updates has made no difference to Excel's
behavior at all. I printed the entire workbook to PDF again, this time
with 6 worksheets in it following some changes I made last week. All
worksheets are set to print 1 page tall by 1 page wide. I get three
PDFs as output: one PDF with four pages, and two PDFs with one page
each.
However, after thinking about it a bit I have determined how Excel is
deciding where to divide the documents up. The workbook I am printing
used to be three separate Excel documents that I decided to
consolidate in to a single document. Excel is breaking up the output
so that you get one additional output file for every copied worksheet.
The four sheets that end up in the same PDF document were all in the
same workbook originally, and the other two worksheets were copied in
from other workbooks.
I tested this theory out with a new document and was able to reproduce
the behavior.
=== Steps To Reproduce ===
1) Create a worksheet using File => New Worksheet.
2) Enter some text on to the worksheet. Create two additional
worksheets using the + icon at the bottom of the Excel window,
entering some text on each.
3) Go to File => Print. In the Print dialog, select "Entire Workbook"
under "Print What." The little preview window shows a single document
with 3 pages. Select PDF => Save as PDF... and choose a save location;
hit OK. Excel prints one PDF document with three pages.
4) Keeping the first document open, open another Excel workbook. From
the newly opened workbook, right click a worksheet tab and select
"Move or Copy". Copy the worksheet from the second document in to the
first document created in step 1 (make sure the "Create a Copy"
checkbox is selected).
5) Go to File => Print. In the Print dialog, select "Entire Workbook"
under "Print What." The little preview window shows a single document
with 4 pages. Select PDF => Save as PDF... and choose a save location;
hit OK. Excel prints two documents: one with three pages, the other
with one page. The single page document is the worksheet copied in
during step 4.
This behavior repeats itself for every worksheet copied in to the
document created in step 1, even if the source document for the copied
worksheet is the same document. So, there's a 1:1 relationship between
copied worksheets and additional unexpected output documents when
saving to PDF from the target of the worksheet copy operation.
Clearly this is a bug, since it is certainly not the expected
behavior, and it's not the default behavior for a multi-worksheet
document when all the worksheets are created in the original document
(rather than being copied in). Is there a way to formally file this
bug with the Mac BU/Excel team at Microsoft?
I expect that an obvious workaround will be to create all the
worksheets in the original document and just select all/copy/paste to
copy the worksheet contents from one workbook to another, although I
have not tested that yet.
Thanks,
- max
