+ Reply to Thread
Results 1 to 2 of 2

Editing links using find replace

  1. #1
    Registered User
    Join Date
    10-19-2007
    Location
    North Carolina USA
    MS-Off Ver
    Excel MSO 2019 64-bit
    Posts
    14

    Editing links using find replace

    When I try to edit links referencing various spreadsheets on our network, a window pops up for each cell with a link, requiring that the file be selected from the network folder / location.
    In the past I've been able to just do a "global" change in the like file location and the spreadsheet would update for the new file... but now each time I'm prompted to define the file.
    There are literally thousands of cells with links to update and so it's impractical to do it manually. Any feedback about this would be greatly appreciated.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Editing links using find replace

    This generally indicates that the file at the requested link does not exist. It is prompting you to select a file so it can establish a valid link.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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. Editing spreadsheet while Find & Replace is open
    By sheroom in forum Excel General
    Replies: 1
    Last Post: 05-13-2013, 08:00 AM
  2. Use Excel VBA for editing and find/replace in a Word document
    By drdavidge in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 01-05-2013, 06:10 AM
  3. Find and Replace Formula Links
    By Werner Rohrmoser in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 07:05 AM
  4. Find and Replace Formula Links
    By Werner Rohrmoser in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 04:05 AM
  5. [SOLVED] Find and Replace Formula Links
    By Werner Rohrmoser in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  6. Find and Replace Formula Links
    By Werner Rohrmoser in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  7. Find and Replace Formula Links
    By Werner Rohrmoser in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 PM
  8. [SOLVED] Find and Replace Formula Links
    By Werner Rohrmoser in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 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