+ Reply to Thread
Results 1 to 2 of 2

Some links not updating

  1. #1
    Registered User
    Join Date
    03-30-2018
    Location
    CHICAGO, IL
    MS-Off Ver
    MICROSOFT OFFICE STANDARD 2010
    Posts
    2

    Some links not updating

    Hi Everyone!

    New to the forum so thanks in advance for your time (^_^)

    So here's my issue, I have a file linking to other workbooks.

    Most update just fine but a couple of them won't update without me opening the source. Any idea to why this is?

    FYI:

    I do have access to all of the files,
    1 of the 2 are password protected via the [General Options]. I do have other worksheets pulling from the password protected one and updates the values just fine.
    Most of the files are tables.



    I can't attach pictures/files yet but the error I'm getting is "Warning: Open source to update values" via [edit links]
    2 says this error, others say "OK"

    and when I try to enter the formula it thinks its a link so I can't post it right now... :-(

  2. #2
    Registered User
    Join Date
    03-30-2018
    Location
    CHICAGO, IL
    MS-Off Ver
    MICROSOFT OFFICE STANDARD 2010
    Posts
    2

    Re: Some links not updating

    What I know so far:

    NOTE: Syntax below are just examples, not exactly what I need help with. I replaced the "AT" symbol with "&" because it thinks its a link ... grrrr lol

    I know that for external tables, I cannot use the syntax below. Otherwise it will require me to open the source and values will be blank.

    =IFERROR(INDEX(t_CodeActual[Code Actual],MATCH([&[ZSF Material]],t_CodeActual[Code Actual],0)),[&['#PKG Code]]).

    Instead I use the syntax below

    =IFERROR(INDEX('FILE LOCATION.xlsx]Summary'!$B$1:$B$500,MATCH($A4,'FILE LOCATION.xlsx]Summary'!$A$1:$A$500,0)),"")

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Need help with two issues: 1) Not updating links and 2) breaking links in workbook
    By mmayo713 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-23-2018, 11:55 AM
  2. Updating Links
    By JAKEFULLER in forum Excel General
    Replies: 2
    Last Post: 09-16-2014, 02:57 PM
  3. After Updating Links the Edit Box Opens, but all links are "OK"???
    By FLSnuffy in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 08-06-2012, 07:47 AM
  4. Excel Links Not Updating, But All Links status are ok
    By DJPROLE in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-04-2011, 10:44 AM
  5. Excel 2007 : some links not updating.
    By fireworks in forum Excel General
    Replies: 5
    Last Post: 05-03-2009, 04:47 PM
  6. Replies: 0
    Last Post: 04-01-2009, 01:10 PM
  7. links not updating
    By Utkarsh in forum Excel General
    Replies: 1
    Last Post: 06-26-2006, 12:35 PM

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