Skip to main content
F
frederickr73805091
New Participant
October 25, 2017
Question

Issue with tags on converting Excel file to PDF

  • October 25, 2017
  • 2 replies
  • 3449 views

I have an excel spreadsheet 88 pages long.   When I convert to PDF, it place all the table headers inside the first table row tag.   Understand?  all 88 pages of the headers are inside the first tag.  They should be in the proper tag at the proper location (i.e., each individual page).

Why is it doing that?  it will take me forever to manually click and trag 88 pages of table headers to the right location.

    This topic has been closed for replies.

    2 replies

    M
    michaels4850939
    New Participant
    June 1, 2022

    What has helped me with this issue is to first strip away the tags brought in from Excel (Accessibility >> Reading Order >> Clear Page Structure). Then I have Acrobat autotag the document. Although this is not perfect, it saves me a lot of time trying to fix issues imported from Excel.

    Meenakshi Negi
    Community Manager
    Meenakshi NegiCommunity Manager
    Community Manager
    December 18, 2017

    Hi Frederickr,

    Sorry for the delay in response.

    As you are experiencing an issue with the tags, please let us know the Adobe Service you are using to convert the file to PDF.

    If you are using the desktop application, please share the dot version of that application.

    Take help of the steps mentioned here Identify the product and its version for Acrobat and Reader DC to check the dot version.

    Did you check if this is an issue that occurs with other excel files too? Try to replicate the issue with other files.

    Is it possible to share the file with us, so we can check it on our end?

    If yes, use the steps provided here How to share a document to share the document

    Let us know if you have any questions.

    We will be waiting for your response.

    Regards,

    Meenakshi

    F
    frederickr73805091Author
    New Participant
    December 27, 2017

    Our client wanted an Excel spreadsheet converted to PDF, but with the Excel print settings set to “repeat header row on every page” when printing. So when you convert to Excel, every page of the PDF has the header row. The client didn’t understand that meant 73 pages of tables instead of one table 73 pages long. But the PDF sent all the header rows for all 73 pages to the first tag of the first page. Why would it do that?

    In other words, the first

    tag had the 73 pages worth of header rows all sent to that location. We can’t run autotag or use TURO because the PDF will freeze up.

    Bevi Chagnon - PubCom.com
    Bevi Chagnon - PubCom.com
    Brainiac
    June 1, 2022

    Hi @frederickr73805091, You definitely didn't get the type of PDF file you were expecting.

     

    Question: are you trying to make an accessible PDF from the Excel spreadsheet? Since you mentioned print settings, it's unclear what the intent of the PDF is.

     

    |    Bevi Chagnon   |  Designer, Trainer, & Technologist for Accessible Documents ||    PubCom |    Classes & Books for Accessible InDesign, PDFs & MS Office |
    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices