Is it possible to suppress the warning when the link is broken? Then, I changed only the following Excel options (i.e. Ask To Update Links = False Set get Workbook = Workbooks. Ask To Update Links = True End Function I wanted to suppress the prompt that asks if you wish to update links to another workbook when my workbook is manually opened in Excel (as opposed to opening it programmatically via VBA). Go to DATA - I've found a temporary solution that will at least let me process this job.all the other are left as is after installation): suggestions in his updated answer (shared for your convenience): https:// Link To Book2Linked book was then deleted so that link in the shared book is unavailable (for sure). I tried including: Excel 2016 I had a similar problem when I created a workbook/file and then I changed the names but somehow the old workbook name was kept. I wrote a short Auto It script that waits for the "Update Links" window to appear, then clicks the "Don't Update" button.A slightly different version of the Modified icon appears when a graphic is modified and one or more instances are updated while others are not.The graphic is no longer in the location from which it was imported, although it may still exist somewhere.A linked file can appear in the Links panel in any of the following ways: This icon means that the version of the file on disk is more recent than the version in your document.
When a linked EPS graphic or In Design document contains links, the links are also combined under a disclosure triangle.You can copy all related files automatically, using the Preflight and Package features.All files placed in a document are listed in the Links panel.The correct solution, if you're looking to open a file without updating links should be: Workbook.
Open(Update Links:=0) Related link: Difference in Ask To Update Links=False and Update Links:=0 Thank you for your interest in this question.In In Copy, the Links panel also displays linked stories.