update links

I have an Excel 2007 macro-enabled template to open all workbooks in a given directory, copy all the sheets back into the template file, then perform some analysis. The issue I'm coming across is that when the code cycles through all the workbooks in my directory, on occasion it will come...

I have an excel file which is linked to other workbooks. When I open the file and are asked to update links and do so, excel crashes. If I don't update the links but do Edit / Links and then Update Values it also crashes when I select the file that has the most links to it. BTW this doesn't...

Hi, can VBA update links (eg: formula like Vlookup, or other references) connected to other workBOOK. As everytime i open the workbook, i have to click on options and click on enable. Please advice. Ped;)

Windows XP Home / Professional Excel 2003 / 2002 VBA 6.5.1024 MS Query 11.8164.8172 Question (concise version): I have several QueryTables in an Excel Workbook. The Query for each was created from the User Interface, and with Microsoft Query, (not VBA so far). During development, I am changing...

I have a workbook with multiple worksheets that all contain similar data except each worksheet is for a specified date range. I want to allow a user of a separate spreadsheet (that contains links to the first spreadsheet) to update links and choose a specific worksheet within the the workbook...

I have a protected worksheet that is distributed for data input. The data input area is limited to a defined area of unprotected cells. I would like to allow the end user the capability of creating a link within the input cells (currently can) and be able to update or change the link (currently...

I'm running a macro which opens up a list of workbooks one at time, updates all links, calculates, saves & closes. Each workbook has a number of links and for one of the links in each workbook a popup appears saying that the workbook wasn't recalculated before save. It then waits for me to hit...