+ Reply to Thread
Results 1 to 2 of 2

Links cannot be updated

  1. #1
    Forum Contributor
    Join Date
    10-16-2010
    Location
    Memphis, TN
    MS-Off Ver
    Excel 2003, 2010
    Posts
    151

    Question Links cannot be updated

    First, let me preface this by saying that I thought I had posted this thread, but I cannot find it so I may have deleted it instead of posting it. I apologize if it is out here twice.

    I have a master file where I maintain basic information about inventory items which is linked to by several different workbooks, most with no problem. I have one workbook though that always comes up with the message "This workbook contains one or more links that cannot be updated."

    When I click 'Edit Links...' the file is the correct file. It is the only link listed and although it says it cannot be updated, the link is apparently good because it pulls the data from the master file.

    I am using a simple INDEX/MATCH lookup that works fine from every other place I use it. Both files are .xlsx files and I am using Excel 2010.

    Does anyone have any suggestions?

    Thanks
    Last edited by jacob@thepenpoint; 11-28-2011 at 09:48 AM. Reason: Problem Solved!
    Jacob Albers
    Excel 2003 & 2010

  2. #2
    Forum Contributor
    Join Date
    10-16-2010
    Location
    Memphis, TN
    MS-Off Ver
    Excel 2003, 2010
    Posts
    151

    Re: Links cannot be updated

    Quote Originally Posted by jacob@thepenpoint View Post

    Does anyone have any suggestions?
    I finally tried what I should have tried first and copied the worksheet to a new workbook. Saved the new workbook, closed it then reopened it. I had no problem with links not updating.

+ 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