Skip to main content
G
GDMW
Participant
September 28, 2019
Question

Excel hyperlink opens pdf only full screen

  • September 28, 2019
  • 2 replies
  • 3577 views

I have a large Excel file with many links to pdf documents. The links were created by a Visual Basic macro. Clicking on a link opens the correct document, but only in full screen mode. Opening the same document any other way (usually Windows File Explorer) does not default to full screen mode. The document's Properties show Page layout and Magnification both as Default and "Open in Full Screen mode" is NOT checked on the Initial View tab. Acrobat Preferences, Full Screen just has checked boxes for "Alert when document requests full screen", "Escape key exits", and "Left click to go forward...". Acrobat Preferences, Page Display shows "Single Page Continuous" Page Layout and 100% Zoom. How can I get the Excel link to open a pdf other than in full screen mode? Thanks for any help!

    2 replies

    S
    Stephen5CC7
    Participant
    March 3, 2021

    I apologise for bumping an old post though I have the exact same issue and wondered if you or anyone managed to find a fix for this.

     

    I regularly hyperlink 1,000s of pdfs in excel for auditing purposes. My problem is this:

    • Openign a PDF from explorer opens an additional tab in the Acrobat window without changing the size of the window, however
    • opening a PDF from a hyperlink in Excel forces Acrobat into full screen mode. 

     

    I dont have any macros running in the Excel file and have the same Acrobat settings as yourself (OP). In addition I have changed my registry entry for bLastExitNormal to '0' but without effect (another forum suggested changing 'bLastExitNormal' from '1' to '0' in the following registry path 'HKCU\Software\Adobe\Adobe Acrobt\DC\ExitSection').

     

    In case it helps I'm running Adobe Acrobat Pro DC (continuous release 2021,001,20142) on Windows 10 (version 20H2)

     

    Any further suggestions would be extremely helpful.

     

    Kind regards

      P
      PrideFive5C53
      Participant
      March 24, 2021

      Same problem here. I don't get the actual Full Screen mode, it just opens Adobe Acrobat in a maximized window (even if it was already open in minimized view). It will begin launching in a smaller window as it was when I last closed it, and then maximizes as the document opens.

      try67
      Community Expert
      try67Community Expert
      Community Expert
      March 24, 2021

      It's probably possible to do it by editing the links' properties, but to do so automatically will require either a plugin or a stand-alone tool. If you're interested I could probably create for you the latter, for a fee.

      You can contact me privately via [try6767 at gmail.com] to discuss it further.

      maxwithdax
      Community Expert
      maxwithdaxCommunity Expert
      Community Expert
      September 28, 2019

      Sounds like the VB Macro has some preferences set or needs some overriding preferences set. Can you edit the parameters of the VB Macro?

       

      -Dax

       

      G
      GDMWAuthor
      Participant
      October 1, 2019
      The same thing happens when I manually Hyperlink from an Excel cell to an "Existing File or Web Page" pdf document, with no macro involved or options beyond "Text to display".
      Terms & ConditionsAccessibility statement
      Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices