Answered
Updated Acrobat X last night and today the pdfmaker addin on Excell 2010 will only create single sheet pdf's & not multiple page pdf's.
When I select the multiple sheets as usual and select the new file destination it quickly flashes thru all of the selected sheets but never opens the newly created pdf nor does it create the pdf to the specified file destination.
Please help! I recently bought X just 2 months ago to be able to continue creating these multi-page pdfs from excel. (last time I updated Office 2010 the pdfmaker addin would no longer run in Excel)
I may never download another Adobe or Microsoft update again...
View Adobe PDF Result
Prompt For Adobe PDF File Name
And this setting is turned OFF:
Fit Worksheet To A Single Page
Not sure about this setting, but check here:
1. Go to Edit> Preferences
2. Click the Convert To PDF category
3. Locate Microsoft Excel in the list
4. Click the Settings button
5. Enable "Convert entire Excel workbook"
Kelly McCathran
Adobe Community Expert
Certified Technical Trainer+