If it is manual then it can be updated through Edit Links, select the link, click Update Values.
The Excel setting ‘Options When calculating this workbook: Update links to other documents’ controls the updating of OLE links only. Update Remote References ) When unchecked, OLE links do not update, even if you select ‘Update Values’ in the Edit Links dialog for that link.
You could link Excel to Word if you like, odd though it looks.
As well as intentionally created links you enter in formulas, links can be created by Excel when you copy sheets from one workbook to another, and those sheets contain references to other sheets either obviously in formulas or less obviously in range names.
If you get a prompt to update links when you open a workbook, but you cannot find any cells containing links, the link is probably in a name. If the source workbooks are open at the same time as the target, the formulas are part of the recalculation chain as normal.
To find where links are used in a workbook, search in formulas for “.xl*!
”; that is, an Excel file name followed by an exclamation mark.
‘HTML’ suits Word tables, ‘Microsoft Word Document Object’ inserts an object with the formatting as in Word.
The Edit Links dialog allows you to choose Automatic or Manual update only for OLE links.In the old environment Windows XP and Office 2003, this same code worked fine.Now after upgrading to Windows 7 and Office 2010, it always displays the Excel box which asks whether to update links or not. Unfortunately, that's not what I want, because this would change the general default and there are a few files where I want this to be able to manually decide whether to update links or not.You can link to text files (eg CSV), other workbooks, databases, and web pages.For further details see MS support and many other websites: https://support.office.com/en-us/article/Create-edit-and-manage-connections-to-external-data-89d44137-f18d-49cf-953d-d22a2eea2d46 RTD / DDE: Real Time Data and Dynamic Data Exchange.I'd like to automatically update links without asking. However, in the meantime I found the reason (although I am still wondering why it's different in the new setup), The Excel sub called from the calls another excel Sub, which opens another file.