These forums are now Read Only. If you have an Acrobat question, ask questions and get help from one of our experts.

Problem convertin Excel file into pdf

annaherr
Registered: Aug 27 2008
Posts: 10

We at the office are using Abode Acrobe 8 Porfessional. We have a problem with converting some of our MS Excel files into PDF format. Our Excel files usually consists of several sheets. When we convert to pdf, Acrobat comes up with the following error:

"Acrobat PDFMaker cannot create Tags for worksheets with Print Area set. Clear the 'Print area' field in Page setup to get this feature.
Do you want to proceed and create a PDF file without Tags?"

We have already cleared the Print Area, but Acrobat still insists on only convertineg the 3rd last worksheet in the file into pdf format, and ignores all the others.

Has anyone else had this problem? I would appreciate your help.

Anna

My Product Information:
Acrobat Pro 8.0, Windows
daka630
Expert
Registered: Mar 1 2007
Posts: 1420
Hi annaherr,

Have you tried this?

With the Excel file open, click on Adobe PDF up on the command menu bar.
Then select Change Conversion Settings from the dropdown.
In the Acrobat PDFMaker dialog, under the Settings tab select/check "Prompt for selecting Excel Sheets"
This is located in the Application Settings pane.

Hopefully this will take care of the issue.

With this setting selected I was able to select three of several work sheets from an Excel file and output these to PDF.



Be well...

Be well...

annaherr
Registered: Aug 27 2008
Posts: 10
Hi daka630

Thanks for the advice. We have tried it and we still have the same problem.

Can you provide some more advice?

Thanks.
xyz
Registered: Sep 1 2008
Posts: 10
Hi annaherr,

Could you share the .xls file you are trying to create a PDF from? You may strip off any sensitive information it might contain.

Thanks
annaherr
Registered: Aug 27 2008
Posts: 10
Hi xyz

How do I share the document?

Anna
xyz
Registered: Sep 1 2008
Posts: 10
You can email the .xls file to me at 'userissues [at] gmail [dot] com'.
Thanks
abhigyan
Expert
Registered: Nov 29 2007
Posts: 223
or upload them to http://share.acrobat.com and post a link here.
annaherr
Registered: Aug 27 2008
Posts: 10
Hi xyz

I have emailed the document to the email address that you provided. We would appreciate any help that you can give us.

Anna
annaherr
Registered: Aug 27 2008
Posts: 10
Hi abhigyan

I have shared the document as you recommended. I would appreciate any help that you or anyone else can give.

Anna
abhigyan
Expert
Registered: Nov 29 2007
Posts: 223
Hi Anna, you'll also need to post a link of the document you have shared for us to be able to see it. You should see an option to get the link on the document at acrobat.com

-abhigyan
annaherr
Registered: Aug 27 2008
Posts: 10
Hi abhigyan

I hope I have this correct now.

https://share.acrobat.com/adc/document.do?docid=20c1b414-81d6-4cd4-bef2-7af0d63c7f82

Thanks for your help.
Anna
xyz
Registered: Sep 1 2008
Posts: 10
Hi annaherr

A workaround could be :
In the Adobe PDF Menu, choose the 'Convert Entire Workbook' option.
Then click on the 'Convert to Adobe PDF' menu and create a PDF.
The PDF will have all the worksheets.
annaherr
Registered: Aug 27 2008
Posts: 10
Thank you, xyz. That worked!

Anna