Skip to main content
M
Michael35754313f2ca
New Participant
February 28, 2024
Question

Excel file PDF Maker "drops" title text over background image

  • February 28, 2024
  • 1 reply
  • 435 views

We have an annual report template in Excel (which we've been using for years now).   

 

Basically contains one worksheet with the title, another with table of contents, then report pages per work sheet.

 

When ready, we uses the PDF Maker saving option to convert into PDF.

 

This year when running the report we're funning into issues of "disappering" text on the cover page.   

 

In Excel we have a worksheet that contains a background image and title text over top such as "this is your annual report".   We click the button to start and complete the PDF conversion.   Adobe Acrobat opens and we (for a second) can see the title text over the image then the text disappears completely.    It's not hidden behind the background image, it's not a font colour we can't see, its just gone.

 

Ideas?

 

Note we have already updated Adobe and Microsoft products to most current version and updates. 

 

Product information is: 

 

Adobe Acrobat 2023.008.205555 (we applied the optional update from Feb 23, 2024)

Excel Version 2401 (build 17231.20236)

 

 

 

 

    This topic has been closed for replies.

    1 reply

    Karl Heinz Kremer
    Karl Heinz Kremer
    Community Expert
    February 28, 2024

    I assume the annual report only gets produced once a year, so the last time you did that, you very likely had an older version of MS Excel, Adobe Acrobat and your operating system. Without having access to a system that correctly produced your report, and then upgrading one component at a time, it's imposible to say what application is to blame here. 

     

    In Excel, you have two ways of creating PDF files: It sounds like you are using Adobe's tools to do that. You will also find a File>Save as>PDF option, which will use Microsoft's PDF generator. Does this produce different results? 

     

    Do you still have last year's Excel document and can try to convert that to PDF using your current system? If so, that would allow us to figure out if the system is actually working, and there might be something wrong with your Excel document. 

      M
      Michael35754313f2caAuthor
      New Participant
      February 28, 2024

      Annual reports are produced on a weekly basis as annual is based on the clients anniversity of purchase vs. calendar year.  On M365 so Office and Windows updates pushed out regularily.  As well Adobe is updated similar pace (we actually just added updates from last week today hoping it fixed the issue - it didn't).

       

      Using the Excel / Microsoft PDF generator gives us the same results when viewing the saved file in Acrobat.  Image is there yet the text isn't.

       

      Thoughts.   Your suggestion is very welcome.

       

      Karl Heinz Kremer
      Karl Heinz Kremer
      Community Expert
      February 29, 2024

      In this case, the probem is not Acrobat. What we do not know is if it's MS Excel that is causing the problem or the actual document. This is where it would be useful to have acces to an older version of an Excel document that used to generate the correct output. If it still generates the correct output today, then we know that the problem must be with the new document, if it also produces the wrong output, then the problem with with Excel, and unfortuantely I would not be able to help you with that. 

      Terms & ConditionsAccessibility statement
      Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices