At first when I tried to do this, I thought something was amiss in Acrobat XI but then I tried doing a print preview in Excel of the entire workbook and it did the same thing. Then when I googled the subject it appears that this is how it works in Excel as well as Acrobat now. Unfortunately, you'll probably need to take the added step of creating PDFs of each sheet and then doing a quick combine in Acrobat.
By the way don't put page numbers in excel. Add them In the PDF. They will be line up right.
Even though This is the Mac version of the Print menu so layout will be different in PC version but should have similar controls. and this setting Print What: should be exactly the same.
This solution does not give me the output I want in PDF which is each worksheet in a workbook numbered beginning at page 1 rather than consecutively. This option does the latter rather than the former.
Yes, I found the same things. I was hoping there would be another solution as I have 100's of worksheets in the workbook and I'll have to repeat this process each quarter. I will try and write a macro in Excel to do this.
What does it do if you leave off numbering in the excel Workbook and Use Adobe to add them.
Wish I had a sample I could use to see what issue is.
When you set to print entire workbook it adds the second sheet to end of the first (including all the pages in the sheet). then the 3rd sheet is added to last page of sheet two and so on.
Okay I see, you need to make PDF of each sheet separately. then open the first PDF and choose insert Pages.
In this case have excel set to show page numbers. In that Case you need to print Sheet.
I have the same problem. All workarounds are timeconsuming. This solution helped 1/2 way:
It offers a macro to restart each sheet at page 1, but it still uses the ++ count of the full workbook. Need total solution as per logosevaluation2013's original request.
I would suggest you go to Microsoft answers Office > PC or Mac.
this link: http://answers.microsoft.com/en-us
Go to appropriate Excel Forum. and ask there are several MVP's That would probably be able to figure out extact method the once you preview to see if it shows Pages numbers correctly The PDF you create will be numbered as you want.
Oh you will need to sign up for or sign in with a LiveID account from MS (its free).
Serveral Of the MVP great on Multiple Platforms. They know as much about Windows as Mac versions of office.
Finally Put this question To OfficeMac Answers forum
The fellow that answered said go to this link and you should find a script to use in Excel to do this:
The fellow is Ron Debruin and about the most expert on VBA and script for Office Mac and PC (Word/Excel/and PowerPont.