Is there a limit to the number of tabs in an Excel workbook that Pro 17 will create?

Report · Jun 26, 2018

I have an Excel 2016 worksheet with 15 tabs. When I attempt to create a PDF with top level bookmarks, so I can split it later, nothing happens. This has occurred when I use the Ribbon Tool Bar, or Pro 17. It does work if the I try a workbook with 2 or 3 tabs.

My current work around is to use Excel's save as PDF, and then go into the PDF file and manually add the bookmarks.

Kludgy and time consuming, is this a known limitation of Acrobat, or is there some setting I need to make in Excel or Acrobat.

Report · Jun 26, 2018

Hello Emesss,

We apologize for the inconvenience caused, as per the description above, when you are converting an excel file multiple tabs to PDF, the bookmarks are not working in PDF, Is that correct?

Please open the Excel sheet, then navigate to ACROBAT tab in the ribbon, click on Preferences>check the settings tab and check "Create Bookmarks" and "Add links" are selected.

You may also refer and try the suggestions from the following Adobe discussions

Excel hyperlinks not working when converted to PDF

Excel hyperlinks not working after convert to PDF

Problem with hyperlinks from Excel to .pdf files with Adobe Reader X

If the issue persists, please share the following details so that we can assist you in a better manner:

Dot version of Adobe Acrobat installed? To identify refer to Identify the product and its version for Acrobat and Reader DC
Is it a Mac or Windows machine and what is the version of OS installed?
The version of Microsoft Office installed?
Is it possible to share the sample file with us so that we can test it at our end? To share the file, please use Adobe Send feature, upload the file, share the link to files via private message only, How Do I Send Private Message

Let us know how it goes and share your findings.

Regards,

Anand Sri.

Report · Jun 27, 2018

Anand,

I tried sending a private message with the requested information, which I hope got to you, but was unable to figure out how to post the file.

The worksheet does not have hyperlinks, just tabs.

Office Standard 2016

Acrobat Pro 2017 Classic 2017.011.30080

Windows 7 Service Pack 1

This did not work with Acrobat XI either, but I was hoping the upgrade would help.

Report · Jul 03, 2018

Hi Emesss,

Sorry for the delayed response and inconvenience caused. I have sent you a private message, please check your email inbox.

Thanks,

Anand Sri.