Excel 2019 link warning pop-up message - can I disable this?

Important Notice


Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

    Hi


    I've 2 PC's on LAN and I run a fairly big (90Mb) excel 2019 SS to manage my business. The SS contains many 100's of images, each image is linked to a PDF file. The image is clicked and the PDF opens to display the information. The PDF files are located locally in same folder as the SS.


    My Windows10 LapTop has been running excel 2019 32bit for couple of years and I somehow resolved the irritating pop-up warning message. However, I can't recall how I did it?


    Today I've replaced a PC on the LAN and installed excel 2019 (tried 32bit and 64bit) and I cannot seem to solve this problem.


    Can anyone please help?

    Hi,


    Have you tested :

    Code
    Application.DisplayAlerts = False

    Hope this will help :)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

    Hi,


    This instruction is usually inserted into a macro ...


    Are you already using a macro in your workbook ?

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

    Hi again,


    If your workbook does not have any macros ... you could test following to be be inserted in the module ThisWorkbook

    Code
    Sub Workbook_Open()
   Application.DisplayAlerts = False
   Application.AskToUpdateLinks = False
   Application.DisplayAlerts = True
End Sub

    Hope this will help :)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

    Hi


    My workbook has many images (photographs). Each image is linked to a pdf file relative to the image. I click the image and the pdf opens. On this new excel '19 install i'm seeing the warning pop-up message.


    On my other PC running same SS and pdf's , the message is disabled - but I don't know how I did it...


    I do use macros but not to open a link to a local file?


    Thanks

    The one thing you can test is to Open your File and copy the macro posted in message #5 in the module named ThisWorkbook


    Once your file is opened, press simultaneously the keys Alt F11 and double-click on the left-side on the module ThisWorkbook


    In the window on the right, you can copy the suggested macro.


    Then Save your file and close Excel.


    Next time, opening your file will trigger automatically your macro ... and you should not get the pop-up message


    Hope this will help :)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

    Hi


    Ok. On my 'main' pc (Win10 Excel '19) I manage and edit my SS. This 'master' version doesn't have problem with the popup warnings (but I do recall some time back I was advised how to stop them...).


    After editing on 'main' computer I copy latest version across LAN to 2nd PC in workshop.


    New PC in workshop Win10 Excel '19 - does have problem with popup messages.


    I have lots of macros on main PC, I don't have problem with popups and the whole SS is transferred to the workshop PC each time.


    If I edited macro on main PC (which doesn't have problem with popups) and transfer to workshop - it will overwrite everything on the workshop PC?


    Thanks

    Have you tested the suggested solution ...???

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

    Yes

    I tried on my workshop PC however I couldn't clearly find the module ThisWorkbook?

    Thank you

    &thumbnail=1



    Where to Store Macros


    In your case, for the module ThisWorkbook, it is The Second Choice ...

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

    Edited once, last by Carim ().

    Hi

    Thank you, I think I've found it.

    However I can't seem to upload/include a screenshot image...


    This code is already in the location;


    Code
    Private Sub Workbook_SheetDeactivate(ByVal Sh As Object)
lastsheet = Sh.Name
End Sub

    Edited 2 times, last by Craigside ().

    Hi


    I've added your code, it now looks like this;

    Code
    Private Sub Workbook_SheetDeactivate(ByVal Sh As Object)
lastsheet = Sh.Name
End Sub


Sub Workbook_Open()
Application.DisplayAlerts = False
Application.AskToUpdateLinks = False
Application.DisplayAlerts = True
End Sub


    Saved it, restarted and problem still exists...

    Hi


    Here is screenshot before adding new code;


    This is with new code added;



    This is the problem message;



    Thanks

    Hi,


    The message you are getting is related to Excel> Options>Trust Center > Trust Center Settings > Trusted Locations > Add New Location


    where you can add your own G:\Art Stuff\ folder


    Hope this will help :)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

    Hi


    I already tried this initially...


    I've tried again, doesn't change anything though...


    Hi again,


    You do need to very carefully examine (and adjust) each and every setting of your Trust Center ...


    since Microsoft Office is after over-protecting you ... even beyond your own will ... !!!


    Forgot to mention the pop-up you are getting has nothing to do with Links ... and Updating Links ... ;)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

    Hi


    I have compared exactly the Trust Centre settings for my Win10 laptop (which doesn't display this problem), and the new Win10 workshop PC, and they are the same?


    I do not understand how/why this problem persists.


    Thank you

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login