+ Reply to Thread
Results 1 to 2 of 2

Stop displaying 'link update' alert

  1. #1
    Registered User
    Join Date
    02-28-2012
    Location
    Rio de Janeiro, Brazil
    MS-Off Ver
    Excel 2007
    Posts
    37

    Stop displaying 'link update' alert

    Hi, this is probably very simple. In the middle of a macro, when it opens a workbook, I get an alert like this:

    This Workbook contains one of more links that cannot be updated.
    To change the source of links, or attempt to update values again, click Edit Links.
    To leave the links as is, click Continue

    What can I add to the code that will prevent this alert from appearing?

    I have tried both

    Application.ScreenUpdating = False
    Application.DisplayAlerts = False

    but they do not work.

    Thanks in advance!

  2. #2
    Forum Contributor
    Join Date
    12-28-2011
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    280

    Re: Stop displaying 'link update' alert

    This is untested, but if you modify how you open the workbook eg to:

    Please Login or Register  to view this content.
    Does it still give you the warning?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1