9/21/2023 0 Comments Removing hyperlinks in excel 2016Notice that from the Table of Contents, you should be able to click on the page names to jump to those locations in the report. Here are three files to refer to: The SAMPLE ANNUAL is last year's file. ![]() None of these hyperlinks work when the file is PDFed! Please help! These worked fine for the last year, I don't see why Excel 2016 would lose this functionality! Via Insert Link / Place in this Document / Named Location Via Insert Link / Place in this Document / "Sheetname!A1" Via the HYPERLINK formula (I know this does not work, tested it just for confirmation) I have tried creating the hyperlinks three different ways: ![]() I have confirmed that "Add Links" is checked in Preferences. (From the Table of Contents to other pages, and from the page titles back to the ToC, etc.) These worked fine in Excel 2007 when I used "Create PDF", but now that I'm remaking this file in Excel 2016, the hyperlinks do not come across in the PDF creation process. I have a workbook created to be a PDF report when complete, with hyperlinks to various points inside the file itself.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |