+ Reply to Thread
Results 1 to 2 of 2

Links do not automatically update

Hybrid View

  1. #1
    Registered User
    Join Date
    10-04-2006
    Posts
    1

    Links do not automatically update

    I have built a summary spreadsheet that pulls information from multiple spreadsheets to display on our Intranet through Sharepoint. When I open the spreadsheet I am prompted to update the links. I want that to be automatic so that employees do not see that everytime they open that page of the intranet. Under Edit/Links I have set the update to "Automatic" and I have set the Startup prompt to "Don't display the alert and update links" yet I continue to get the alert. Is there another flag I am missing. Thanks.

  2. #2
    Valued Forum Contributor
    Join Date
    12-16-2004
    Location
    Canada, Quebec
    Posts
    363
    I am not sure if this would work!

    Sub auto_open()
    Application.DisplayAlerts = False
    End Sub

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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