+ Reply to Thread
Results 1 to 8 of 8

Convert links to values

  1. #1
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit
    Posts
    3,740

    Convert links to values

    I have a "collector" Word document that contains links from various Excel workbooks. Once I update the values in my collector document I want to save it under a different name and convert all of the links to value, because I'll be sending it to an outside entity. I've looked online and find LOTS of help in linking Excel files into Word, but NOTHING about how to then convert those links to values. I'm sure it's easy, but not knowing how definitely makes it hard for me!

  2. #2
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit
    Posts
    3,740

    Re: Convert links to values

    Figured it out. Context is King. Not "Convert Links to Values" but "Convert Fields to Text" gave me the answer. For anyone else looking, here's the fast and easy way:

    Please Login or Register  to view this content.

  3. #3
    Forum Guru macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,701

    Re: Convert links to values

    Do be aware that the Ctrl-A, Ctrl-Shift-F9 approach destroys all fields in the body of the document including, for example, a Table of Contents, hyperlinks and any cross-references. It also has no effect on fields in headers, footers, footnotes, endnotes or textboxes, each of which must be processed separately. If you want to unlink particular content, select that content, then press Ctrl-Shift-F9.
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

  4. #4
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit
    Posts
    3,740

    Re: Convert links to values

    Good to know. Is there another way to convert all links to remote sources to values, without destroying the cross-references within the document?

  5. #5
    Forum Guru macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,701

    Re: Convert links to values

    You can go to File>Edit Links to Files (in the lower right of the screen), then choose 'Break Link' for any link you want to break. Anything fancier would require a macro.

  6. #6
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit
    Posts
    3,740

    Re: Convert links to values

    That "for any link" is the killer. I have about 50 external links in the document, and almost that many internal links.

  7. #7
    Forum Guru macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,701

    Re: Convert links to values

    In that case, as I said, you could use a macro. For example:
    Please Login or Register  to view this content.
    will unlink all external links in the body of the document.

    For PC macro installation & usage instructions, see: http://www.gmayor.com/installing_macro.htm
    For Mac macro installation & usage instructions, see: http://word.mvps.org/Mac/InstallMacro.html

  8. #8
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit
    Posts
    3,740

    Re: Convert links to values

    Sorry it took so long to get back. I only have internet access at work, and I'm off on weekends.

    Macropod,
    Thanks for the macro. Althought I have a macro that will convert ALL fields to values, having this one to convert only the external links will be a big help. Thanks so much!

+ 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. Macro to convert Vlookup formula to Direct links.
    By ankitg2006 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-17-2015, 07:32 AM
  2. convert picture links to actual, embedded pictures?
    By Adinmem in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-13-2013, 04:41 PM
  3. 2010 recent convert, external links REF'ing out!
    By SallyVA in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-09-2012, 05:19 PM
  4. Convert list of text links into Hyperlinks?
    By jaustin008 in forum Excel General
    Replies: 1
    Last Post: 07-08-2012, 04:14 PM
  5. Convert cells to links
    By vbhal in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-24-2011, 08:34 PM
  6. Convert external links to internal
    By Marie J-son in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-26-2006, 11:55 PM
  7. [SOLVED] How do I convert email addresses to clickable links?
    By Rick Wetzel in forum Excel General
    Replies: 3
    Last Post: 02-05-2005, 03:06 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