+ Reply to Thread
Results 1 to 3 of 3

Annoying link update message on workbook open

  1. #1
    Forum Contributor
    Join Date
    06-14-2010
    Location
    Toronto,Canada
    MS-Off Ver
    Excel 2003
    Posts
    145

    Annoying link update message on workbook open

    I have a workbook (BookB) that has come cells linked to a master file (BookA).
    I added some code so that it so that BookA opens and hides automatically when BookB opens.

    A popup message appears as soons as I open BookB tho:
    "This workbook contains one or more links that cannot be updated"

    The link to some of the cells are:
    =VLOOKUP(B444,'I:\xxx\xxx\[workbook name.xls]Sheet1'!Data,2,FALSE)

    Those cells have #REF! at the moment of error, and have valid values as soon as I press continue

    I have selected “Startup Prompt…” from the edit links DB box and selected “Don’t display the alert and update links” and I have Tools-Options-Edit-“Ask to update links” unchecked.
    I also don;t have any defined names with #REF in the Refers To: box (probably disppears when I click continue)

    I don;t want to open BookA first, then BookB. BookA is a master file and don;t want anyone to touch it

    Is there a way to get around the problem?

    THanks

  2. #2
    Forum Contributor
    Join Date
    06-14-2010
    Location
    Toronto,Canada
    MS-Off Ver
    Excel 2003
    Posts
    145

    Re: Annoying link update message on workbook open

    Anyone have an idea to solve this problem?

  3. #3
    Forum Contributor
    Join Date
    06-14-2010
    Location
    Toronto,Canada
    MS-Off Ver
    Excel 2003
    Posts
    145

    Unhappy Re: Annoying link update message on workbook open

    I still haven;t been able to solve this problem
    Please, does anyone have any idea about this OR an alternative would also be nice?
    My manager wants this soon, and I don;t want to go up to him showing this annoying message showing up everytime I open the workbook

+ 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