update links

Hello all, I am on a Mac therefore cannot use Power Query as a solution and avoid what I am trying to do. I have a master workbook that is linked to over 40 other workbooks and draws a set of data from each of them. These workbooks also contain links to other workbooks. I have written a macro...

I have an excel file that I use to update daily schedules. The code is fairly simple yet has intermittent faults due to an unknown reason. The code below opens a file( on teams), updates links and then closes the file, the fault is, sometimes the file will open and close but not update the...

I have 3 workbooks, Wkbk A, Wkbk B, & Wkbk C Wkbk A has some in-cell formulas, vlookups, that reference ranges in Wkbk B & Wkbk C. They work as expected. If Wkbk B or/and Wkbk C is/are closed, and I open Wkbk A, I get the "We can't update some of the links in your workbook right now." I can...

Hello, I have an Excel file with some data entries (20 different variable cells) these data are copied & pasted special in a Word documents (in different portions) every time i change in the data in the Excel sheet i have to go to the word document and update the links there and then print the...

Hello, I have two 2010 Excel workbooks: Book 1 is on a shared drive and linked to multiple other Excel books within the same folder. It automatically updates when opened without a prompt to update. Book 2 is on my local drive linked to a password protected (modify, not open) Excel book...

Hi there I have a link(ed) query... I am working with multiple excel linked files. the structure is something like: Main Folder>> Sub- Folder + Loose Files >>Sub- Folders>> Files Files are linked within as well as between the sub- folders. Problem: Whenever I copy the...

In a xlsm workbook I have an auto open macro that opens a different workbook that has a user form with multiple buttons linked to the master workbook. The user form workbook has no macros, only links to all my VBA code. This was updated from a very old Excel project. When the user form book...

I am migrating from Office 2010 to Office 2016. Previously, when opening spreadsheets with External Links in Excel 2010, the linked cells would retain their stored values until I would select “Update Links”. With Excel 2016, even though I select “Don’t Update” when prompted regarding External...

I am migrating from Office 2010 to Office 2016. Previously, when opening spreadsheets with External Links in Excel 2010, the linked cells would retain their stored values until I would select “Update Links”. With Excel 2016, even though I select “Don’t Update” when prompted regarding External...

Hi i have a workbook open, but i want it update all the links on the page The links from the other spreadsheets are open on other computers that are shared and are saved every 5 mins The current code looks like this Sub UpdateIt() ''This stops any messages popping up on the screen...

Hello all. In my workbook i have a button to update the workbook which i will press several times whilst it is open as the files regally change. It all works well unless i have one of the workbooks open. Is there a way for vba to check to see if the workbook is open, if so then it will skip the...

The following code is giving me a type mismatch error...I am trying to update the links when a tab is activated by a user...this was working yesterday for me which is why its really strange. The linked workbooks on are a network share drive and I have access to both of them.. Workbook1 has...

Hi. While this is my first post, I have been dipping into this board for too many years to contemplate for help on VBA and have always appreciated the resource. I manage a department SharePoint site as an administrator (with limited privileges) for the Sales Team. I have a number of workbooks...

Excel 2007 VBA -- When I open a particular file from the Excel user interface or Win Explorer, the file opens without the "... links cannot be updated" dialog. When I use a empty new file and a vba code of only "Workbooks.Open filename", it opens with the dialog. I have purged the file of all...

Hello, I have an issue with worksheet links through a network drive. System information: Windows 7 Professional SP1 64 bit Microsoft Office 2010 Professional I have two workbooks, v1_File and v3_File. Both are Microsoft Excel Macro Enabled workbooks and are both saved on a network drive. The...

Hi I've got a workbook with a dashboard in it and it contains links to other workbooks. I changed settings so that the links are updated automatically and the dashboard is continually up to date. For some reason now, the links not only don't update automatically but when i click on Edit Links...

Our Lisbon, Portugal location is trying to turn off an old Terminal Server. For years they used Excel 2003 on this TS and would have many links between several excel files and would update/refresh these links without issue. we are now moving them off of TS to PC's with Excel 2010, but now...

I have a number of spreadsheets that have links to several source data files. I want to be able to turn off the link updates so that a user has to manually choose the actions to make the updates. I know in Tools - Options there is the checkbox to always ask to update links, which is what I...

I have a Powerpoint presentation that is linked to one Excel workbook. The document contains about 60 linked objects. This Powerpoint is shared among multiple users who update the data in the Excel file and then they update the links in the Powerpoint. We have trouble getting the users to...

I have an Excel Sheet that we use to track project progress. This sheet is open almost around the clock as people are constantly entering information into this sheet. I then have a PowerPoint presentation which links to this Excel file and grabs some graphs from it and then displays this...