+ Reply to Thread
Results 1 to 2 of 2

Stop Links from changing type

Hybrid View

jomili Stop Links from changing type 08-02-2017, 09:26 AM
jomili Re: Stop Links from changing... 08-08-2017, 09:38 AM
  1. #1
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit, 2108, build 14326.21018
    Posts
    4,065

    Stop Links from changing type

    I have a worksheet with about 40K Vlookups to remote workbooks. The path always follows this general path:
    \\12aust1001fs01\share10011\Budget\SOBUDGET\Projections\CY 2017\2017 07 Jul Projection\Projection Docs
    After opening and closing my workbook a few times, and moving it from one location to another, I notice the path has changed to
    S:\Budget\SOBUDGET\Projections\CY 2017\2017 07 Jul Projection\Projection Docs
    After this change, if I open one of my source workbooks, the formula doesn't update because it doesn't seem to recognize the S. How do I stop the original link from changing?
    I know I'm not stupid, but I suspect I'm a lot stupider than I think I am

  2. #2
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit, 2108, build 14326.21018
    Posts
    4,065

    Re: Stop Links from changing type

    Still in need of help on this one.

+ 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. Stop updating links
    By Guestie in forum Excel General
    Replies: 0
    Last Post: 06-03-2016, 07:25 PM
  2. Replies: 5
    Last Post: 11-24-2015, 11:33 PM
  3. Replies: 2
    Last Post: 09-25-2013, 09:43 AM
  4. Stop links from breaking
    By HSU in forum Excel General
    Replies: 4
    Last Post: 02-11-2011, 09:53 AM
  5. How do I stop Pivot Chart changing chart type by itself?
    By lealea1982 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 04-03-2008, 07:49 AM
  6. [SOLVED] Edit Links: Changing links on a protected worksheet
    By Halibut68 in forum Excel General
    Replies: 0
    Last Post: 04-28-2006, 06:10 AM
  7. RTD Links, how to start and stop them
    By carlos18081973@hotmail.com in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-28-2005, 08:06 AM

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