Publishing to PDF from Excel


Say,When I choose publish under options & I am able to "publish what" which includes entire "workbook". Even though I choose entire time after time - the settings always reverts to "active sheet". How can I set the default to the entire workbook?
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.


What version of excel you are using? if its excel 2007 and above simply do this "In the Save as type list, click PDF"

Hope it helps.
shaunwinginAuthor Commented:
Excel 2010

In the save as type list, select/click PDF, then you can publish your entire workbook in PDF.

Hope that helps.
HTML5 and CSS3 Fundamentals

Build a website from the ground up by first learning the fundamentals of HTML5 and CSS3, the two popular programming languages used to present content online. HTML deals with fonts, colors, graphics, and hyperlinks, while CSS describes how HTML elements are to be displayed.

shaunwinginAuthor Commented:
raypedong, this brings up the dialogue box I refer to and automation glitch persists....

Can you elaborate more the automation glitch.. i cant quite get it.. my apology. If you mean to publish the entire workbook then by clicking options and selecting entire workbook will do the trick. See screenshot
shaunwinginAuthor Commented:
Even though I choose entire time after time - the settings always reverts to "active sheet". How can I set the default to the entire workbook?
Harry LeeCommented:

What you are experiencing is designed purposely in Excel. It's not an error. Just like when you are printing a document in Excel, by default, it will print only the Active Sheet instead of the entire workbook.

One way you can get that done easier is to use a macro to save the workbook as PDF.

The syntax will be similar to the following.

Sub Macro1()
    ChDir "C:\Temp"
    ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, Quality:=xlQualityStandard, _
        IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:= _
End Sub

Open in new window

The above code, ActiveWorkbook, instead of ActiveSheet by default will get Excel to save the Entire workbook instead of just the ActiveSheet.

As you see, there is no filename specified in the syntax, which will force Excel to save using the exact file name but instead of xls or xlsx, it's in PDF.

Also, since I have a temp folder in C:\, I can use this, but you will have to come up with a file path for the PDF to be saved in.

You can consider putting a Custom Menu Item or Button in Excel Ribbon to run the macro from Personal.xlsb so that it's available to all workbooks you are working on.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.