Shaun Wingrin
asked on
Publishing to PDF from Excel
Hi
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?
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?
ASKER
Excel 2010
Hi,
In the save as type list, select/click PDF, then you can publish your entire workbook in PDF.
Hope that helps.
In the save as type list, select/click PDF, then you can publish your entire workbook in PDF.
Hope that helps.
ASKER
raypedong, this brings up the dialogue box I refer to and automation glitch persists....
Hi,
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
Publish-all-workbook.png
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
Publish-all-workbook.png
ASKER
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.