I have the feeling both questions are [no]s... but I'll ask anyway...

1) Is it possible to have excel print a file (with multiple worksheets) into one pdf AND maintain the page numbers (&[page] and &[pages]) from the individual worksheets? I only know how to do one or the other of these, just not together.

2) Why are some of the pages rotated after printing (e.g. a worksheet with a landscape layout has the printed page rotated to profile - note this isn't the same as the layout being rotated; just the printed page being rotated). This doesn't happen every time and it changes pages sometimes... I beginning to think my PDF creator is trying to be smart; but asking just in case there is something in Excel that could lock this down.

Thanks

4/15/2014 8:49:35 PM

I'm not clear what you mean with #1, you want a single file with Worksheet1 Page1,Page2,Page Worksheet 2 Page 1, Page 2 etc...? just export to PDF and combine

For number 2 are you printing to PDF with something or are you exporting to PDF directly? I think mine gets it right but I will check tomorrow

4/15/2014 9:13:58 PM

1) Yes. I want a single PDF from excel. The spreadsheet has 20+ worksheets; most of the worksheets are multiple pages. Thus I want to print the entire spreadsheet to 1 PDF, but have the page numbers remain per worksheet - Excel automatically changes the page numbers to the entire document when printing as 1 PDF (say there are 10 sheets, 2 pages each; excel says sheet 1 of 20, 2 of 20, etc.; I want 1 of 2, 2 of 2 for WS1, 1 of 2, 2 of 2 for WS2, and so on. I could print these individually and combine, I know that. Trying to avoid the time suck that that is.

2) We use PDF995, which shows up as a printer (printing to PDF); though I forgot MSO now has native PDF saving capabilities; maybe I should try that.

4/15/2014 10:22:11 PM

I typically use doPDF but you'll probably have issues similar to PDF995.

4/16/2014 6:49:13 AM

So for #1 you are trying to do:

Quote :

"This lets you add page numbers to multiple worksheets in a workbook, but each worksheet contains its own set of page numbers. For example, if your workbook contains two worksheets that are both two pages long, the first worksheet will contain two pages numbered 1 and 2. The second worksheet will also contain two pages numbered 1 and 2."

http://office.microsoft.com/en-us/excel-help/insert-and-remove-page-numbers-on-worksheets-HA010342619.aspx

4/16/2014 7:32:53 AM

that's pretty much what I did; the closest I can get is get have each worksheet start over at 1; but the total number of pages is still for the entire document.

4/16/2014 12:38:21 PM

you followed microsoft's directions and they don't work? or are you trying to do something different than they describe

4/16/2014 2:08:58 PM

Those work... until you print the document to a single file.

4/16/2014 2:29:19 PM

it works exactly like the describe for me

it sounds like your worksheets are set on "Auto" which is described as:

Quote :

" For example, if your workbook contains two worksheets that with both be printed as two pages, you would use this procedure to begin the page numbering for the second worksheet with the number 3."

to make each worksheet start with one make sure to:

Quote :

"1.On the Page Layout tab, in the Page Setup group, click the Dialog Box Launcher Button image next to Page Setup. 2. On the Page tab, in the First page number box, type the number that you want to use for the first page."

wait, is it the total page number that's not working? the "of &[page]" part? looks like you aren't the only one:
http://www.teachexcel.com/excel-help/excel-how-to.php?i=133857
http://www.mrexcel.com/forum/excel-questions/529982-group-multiple-worksheets-where-page-numbering-each-worksheet-x-y-page-pages.html
http://www.mrexcel.com/forum/excel-questions/467817-total-number-pages-per-worksheet-2.html
http://www.excelguru.ca/content.php?161


[Edited on April 16, 2014 at 3:25 PM. Reason : .]

4/16/2014 2:58:53 PM

right; the &[pages] always reverts back to the total in the file instead of the worksheets.

4/16/2014 3:29:01 PM