Sunday, March 28, 2010

Acrobat 9.1.1 pro, Excel 2007,...

I have just upgraded from CS3 to CS4 Design Standard. I have been accustomed to producing PDFs from Excel 07 with Acrobat 8 pro, normally selecting a number of sheets from the same Excel workbook to creat a single PDF. I normally use the ''page # of?##'' option in Excel for my footer, which would come through just fine in Acrobat 8. In Acrobat 9, each page is instead reflected as ''Page 1 of 1'' in the PDF file, and I cannot get Acrobat to properly reflect the true number of pages.

As a late upgrader, I know there are likely others who have run into this problem, and I would greatly appreciate learning what the solution might be. Thanks for your assistance.

Hat

Acrobat 9.1.1 pro, Excel 2007,...

In the past, the page number issue actually was an OFFICE problem that required an update of OFFICE. Since you said it worked in AA8, I am at a loss. If you did the update to OFFICE 2007 along with the AA9 upgrade, then it may indeed be an office issue.

Acrobat 9.1.1 pro, Excel 2007,...

I've been using Office 2007 for just over two years, and have loved the flexiblity that Acrobat has provided. I stay current with all updates on both the Office and Adobe front.

I should have noted in my original question that I always use the Acrobat ribbon in Excel when I create a pdf. About an hour ago I came across a work-around that another individual came up with to solve the pagination problem (on another on-line resource): he didn't use the ribbon, and instead printed to the Adobe PDF printer, and selected the option to print the entire workbook. Sure enough, that works, so I was really glad to come across it. But, the convenience of the ribbon is still my preference.

The toolbar item (PDF Maker) is often used by folks due to convenience or simply not trying the other option. You might want to try both and note the size difference. There are a lot of features that can be turned off in PDF Maker that will reduce the size. The major reason to use the PDF Maker is typically for the bookmarks and links that it will retain for the PDF (these are lost with the printer by itself).

I have found some differences between PDF Maker and the Adobe PDF printer results for OFFICE 2007. That may be the issue you are running into. If found it was a result of OFFICE 2007 and not Acrobat, at least that was the conclusion I reached. I was looking at some graphics issues in PPT files.

Since the printer worked for you, you might want to check the preferences in PDF Maker to see if one of them is causing your problem. That is about all I can suggest.

No comments:

Post a Comment