+ Reply to Thread
Results 1 to 3 of 3

excel spreadsheet "automatic update of links has been disabled"

Hybrid View

  1. #1
    Registered User
    Join Date
    01-25-2021
    Location
    Japan
    MS-Off Ver
    2019
    Posts
    7

    excel spreadsheet "automatic update of links has been disabled"

    hey all I tried doing some work this morning and came across this message: "automatic update of links has been disabled". When I clicked Enable content. it prompted me with this message "we cant update some of the links in your workbook right now. You can continue without updating their values, or edit the links you think are wrong." I have no clue what to do here and this report is due at the end of teh week. any help would be amazing :3

  2. #2
    Valued Forum Contributor
    Join Date
    02-04-2009
    Location
    Texas
    MS-Off Ver
    Excel 2016
    Posts
    667

    Re: excel spreadsheet "automatic update of links has been disabled"

    The workbook contains links to another file probably in some copied formula.
    Search CTRL-F - Change the setting to look in workbook - make sure search in formula is checked - look for \\ or [ - you will find a url inside of a formula.
    OR
    Sometimes the link is in Conditional formatting
    OR
    Sometimes this link is in the named range.
    If this solves your issue, Mark thread as Solved & Add Reputation.

    Thanks!

  3. #3
    Registered User
    Join Date
    01-25-2021
    Location
    Japan
    MS-Off Ver
    2019
    Posts
    7

    Re: excel spreadsheet "automatic update of links has been disabled"

    Thank you! Btw how do i mark this thread as "SOLVED"?

+ 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. Replies: 1
    Last Post: 01-04-2019, 03:12 AM
  2. Replies: 1
    Last Post: 11-20-2018, 08:26 AM
  3. [SOLVED] Excel 2010 -- "Visual Basic" "Macros" and "Record Macro" all disabled.
    By NicholasL in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-07-2017, 06:11 AM
  4. automatic update of links has been disabled
    By kisanvikas2015 in forum Excel General
    Replies: 1
    Last Post: 06-11-2015, 02:27 AM
  5. Automatic update of links has been disabled
    By swed in forum Excel General
    Replies: 1
    Last Post: 01-27-2011, 06:03 AM
  6. Replies: 2
    Last Post: 10-23-2010, 08:36 AM
  7. Replies: 0
    Last Post: 12-07-2008, 01:25 PM

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