+ Reply to Thread
Results 1 to 4 of 4

Data Connections - Moving File

Hybrid View

  1. #1
    Registered User
    Join Date
    03-26-2017
    Location
    Winchester, England
    MS-Off Ver
    Excel 2007
    Posts
    3

    Data Connections - Moving File

    Hi,

    I have a file "Master" with around 20 other workbooks containing pivot tables connected to it. I have been developing this system on my PC and now I am ready to launch onto company server.

    I have moved all files (including "Master") into desired location and now connections do not work.

    Does any one know how I can re-instate the connections to all 20 workbooks?

    Any help gratefully received.

    Thanks

  2. #2
    Forum Expert
    Join Date
    04-01-2013
    Location
    East Auckland
    MS-Off Ver
    Excel 365
    Posts
    1,347

    Re: Data Connections - Moving File

    Just edit the external links?

    https://support.office.com/en-us/art...4-8756a5301253
    If you want something done right... find a forum and ask an online expert.

    Time flies like an arrow. Fruit flies like a banana.

  3. #3
    Registered User
    Join Date
    03-26-2017
    Location
    Winchester, England
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Data Connections - Moving File

    Thank you for the response.

    I have looked at this option previously but for some reason this option is unavailable (grey'd out) Any idea why this may be?

  4. #4
    Forum Expert
    Join Date
    04-01-2013
    Location
    East Auckland
    MS-Off Ver
    Excel 365
    Posts
    1,347

    Re: Data Connections - Moving File

    that sounds line the links have been broken already.
    Maybe you would need to upload the file or you could try to go back to a version you know has the links and work from there.

+ 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. Powershell code to count data connections and return output to a text file
    By Jack C in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-29-2014, 04:05 AM
  2. [SOLVED] Opening, refreshing data connections, saving and closing file with VBA
    By jtukes in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-22-2013, 03:31 PM
  3. Replies: 2
    Last Post: 05-24-2012, 08:43 AM
  4. Replies: 0
    Last Post: 03-07-2012, 06:53 AM
  5. Replies: 3
    Last Post: 04-21-2011, 12:54 PM
  6. Replies: 1
    Last Post: 09-16-2008, 04:11 PM
  7. Connections to xla file
    By kingdt in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-26-2008, 05:42 PM

Tags for this Thread

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