• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

Excel footer doesn't appear on PDF when converting to Adobe PDF

New Here ,
Jul 07, 2020 Jul 07, 2020

Copy link to clipboard

Copied

Hi everyone,

I have created a footer on an Excel file with some images and a text. When I convert it to a PDF file using Adobe Acrobat, I can see the images, but not the text. When I do normal "Save as" and choose ".pdf" directly from Excel, everything works fine though.

Did anyone encounter with this issue before and do you know how to fix this?

excel.jpg

Here are Acrobat PDFMaker settings:

pdf_maker.jpg

P.S. Using "Save as" from Excel is not convenient when converting a lot of Excel files. When using Adobe Acrobat I can convert as many files at a time.

TOPICS
Edit and convert PDFs

Views

3.9K

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Jul 07, 2020 Jul 07, 2020

Copy link to clipboard

Copied

I wonder if it's a scaling issue, and it is just not all fitting on the PDF page. Have you tried ticking the 'Fit Worksheet to a single page' or 'Fit to paper width' option to see if it all shows up that way?   Might be worth a  try.

My best,

Dave

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Jul 08, 2020 Jul 08, 2020

Copy link to clipboard

Copied

Hi Dave,

Thank you for your response, however, neither of the options worked for me. I have attached an example.xlsx file to my initial post and would appreciate if you could have a look into it. Thank you very much.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Jul 08, 2020 Jul 08, 2020

Copy link to clipboard

Copied

OK... this is getting more interesting.  I opened your Excel file, did a Save as, and went to the Acrobat ribbon in Excel.

In the Preferences there, I turned on Fit Worksheet to a single page.  Then I hit the Create PDF button.  Here is a screenshot of the  bottom/footer of my result:

excel-to-pdf-1.jpg

I am seeing both text and images in the page footer.  From my desktop, right clicking on the XLS file, and choosing Convert to Adobe PDF yields a similar result.

What more can you tell me about your software & process you used?

 

My best,

Dave

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Jul 15, 2020 Jul 15, 2020

Copy link to clipboard

Copied

Great, that's the result I am expecting. If you did no changes to the downloaded .xlsx file, there is most probably nothing wrong with Excel settings and everything is all about Adobe.

I don't think I have more info to add, except for Adobe version: Adobe Acrobat X (v10.1.16).

We basically did the same thing, except you get a better result 🙂

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Jul 15, 2020 Jul 15, 2020

Copy link to clipboard

Copied

I don't have your XL file in front of me currently,  but you  might want to see what typeface was used in the footer, and use it in another part of the file (not the  footer) to see if the conversion process is getting derailed by the font... just  thinking aloud here.

My best,

Dave

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Jul 15, 2020 Jul 15, 2020

Copy link to clipboard

Copied

LATEST

The font is Calibri with the size of 11. The same is used throughout the spreadsheet, but the issue is happening only with the foother.

I don't think the problem is in Excel, since it works just fine when I do "Save as" and choose .PDF as an output. The problems starts when I use Acrobat PDFMaker utility.

Anyway, thank you for your assistance.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines