Results 1 to 5 of 5

Don't update links on workbook open

Threaded View

dylanemcgregor Don't update links on... 08-12-2009, 01:49 PM
royUK Re: Don't update links on... 08-12-2009, 01:55 PM
dylanemcgregor Re: Don't update links on... 08-14-2009, 07:14 PM
shg Re: Don't update links on... 08-14-2009, 07:26 PM
dylanemcgregor Re: Don't update links on... 08-14-2009, 07:32 PM
  1. #1
    Registered User
    Join Date
    06-26-2006
    Location
    New York
    MS-Off Ver
    Office Pro 2003 primarily, some 2007
    Posts
    85

    Don't update links on workbook open

    I have a workbook that has many cells that link to a server on the other side of the planet. If I manually open this workbook I get the "This workbook contains links to other data sources." And the option to "Update" or "Don't Update"

    If I choose to not update, everything works great. If I choose to update, the worksheet takes 10-15 minutes to open. I have tried to go to tools-->options-->Edit and uncheck "ask to update automatic links" but this makes the default behavior updating.

    I want to open this workbook using a scheduled task and a batch file, and have it not update, and then run a macro. Any suggestions on how to do this?

    P.S. I searched for "don't update" and had zero results. My apologies if this is a common question.
    Last edited by dylanemcgregor; 08-14-2009 at 07:34 PM.

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