+ Reply to Thread
Results 1 to 2 of 2

How do I maintain data values while removing external links?

  1. #1
    Registered User
    Join Date
    Sacrament, CA, USA
    MS-Off Ver
    Excel 2010

    Question How do I maintain data values while removing external links?

    I have a large (25 tabs) workbook that contains external links to other data sources on our Local Area Network (LAN). I need to send the information and reports in that workbook to another person who does not have access to our LAN, which means the links will not work. Is it possible to convert all of the formulas within the workbook to value-only entries, without copying and pasting each page individually?

    This is in alpha test, so no rush on an answer.


  2. #2
    Forum Guru AlKey's Avatar
    Join Date
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365

    Re: How do I maintain data values while removing external links?

    I think Save As your workbook and remove data source connection. It should leave data intact.
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

+ 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. Saving external links without saving data values
    By john@axiomatix in forum Excel General
    Replies: 2
    Last Post: 06-18-2013, 05:58 AM
  2. maintain hyperlinks with external links
    By nisbett in forum Excel General
    Replies: 0
    Last Post: 10-06-2011, 06:32 PM
  3. Replies: 0
    Last Post: 12-07-2008, 01:25 PM
  4. [SOLVED] Removing External Links
    By MarkN in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-21-2006, 11:50 PM
  5. removing values not links
    By Jase in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-17-2005, 02:07 AM

Tags for this Thread


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