+ Reply to Thread
Results 1 to 5 of 5

Update workbooks links witout opening the workbooks

  1. #1
    Registered User
    Join Date
    11-19-2014
    Location
    Capetown South Africa
    MS-Off Ver
    2013
    Posts
    37

    Update workbooks links witout opening the workbooks

    Hi There

    I was wondering if was possible to update workbooks links ,that is linked to another workbook to retrieve certain information, without opening the workbook ?

    to explain the situation:

    there is workbook A ( time sheet ) and workbook B (project list ) , workbook A is retrieving information from workbook B , so when workbook B is updated and Workbook A is opened in excel the links / information is updated.
    but workbook A cant be open in excel because PC doesn't have excel and is opening it through Onedrive account online, and Onedrive online doesn't support links at current time.
    solution will be is for me to open workbook A with excel from my side through excel and update it save it and close, but another issue is that there are multiple workbook A's and to open update each one wont be practical, so is there a way to update multiple workbooks without opening each one?
    Any help would be appreciated


    Edwin

  2. #2
    Forum Moderator dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Re: Update workbooks links witout opening the workbooks

    Good morning no1freeman

    I’m not sure about refreshing links without opening the workbook.

    However, you can read information from closed workbooks. The link here shows several different methods of accomplishing this.

    HTH

    DominicB



    http://www.erlandsendata.no/english/...adfromclosedwb

  3. #3
    Registered User
    Join Date
    12-08-2012
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    34

    Re: Update workbooks links witout opening the workbooks

    You could also turn screen updating off then open and make changes then close the workbook and turn screen updating back on.
    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    12-08-2012
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    34

    Re: Update workbooks links witout opening the workbooks

    Sorry didnt read full question!

  5. #5
    Registered User
    Join Date
    11-19-2014
    Location
    Capetown South Africa
    MS-Off Ver
    2013
    Posts
    37

    Re: Update workbooks links witout opening the workbooks

    @grantastley. No worries. .
    @dominicb. I had a look at the link, thanks! But not what looking for. Don't nesaseraly want retrieve information I'm just looking for way for the information to update in workbook A so that the person opening it in OneDrive excell will have the most updated information on his workbook A which is retrieve from workbook B from my side.

+ 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. Update links between workbooks
    By camri6 in forum Excel General
    Replies: 1
    Last Post: 12-09-2014, 06:39 AM
  2. Replies: 1
    Last Post: 02-02-2014, 08:04 PM
  3. Automatically update links to other workbooks
    By krabople in forum Excel General
    Replies: 0
    Last Post: 10-09-2006, 08:31 AM
  4. how do I activate links without opening external workbooks?
    By teh_chucksta in forum Excel General
    Replies: 0
    Last Post: 08-29-2005, 07:05 PM
  5. [SOLVED] Can you update links between workbooks without them both open?
    By Nicolle K. in forum Excel General
    Replies: 1
    Last Post: 01-07-2005, 04: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