Opening Workbook via VBA Code If you are using Excel VBA to open the Workbook the problem can be addressed in the Workbook Open Method. Open File Nmae:= _ "C:\My Documents\Linked Book.xls", Update Links:=xl Update Links Always End Sub Sub Open Dont Update() Workbooks.
Open File Nmae:= _ "C:\My Documents\Linked Book.xls", Update Links:=xl Update Links Never End Sub Sub Open Update Links Per Settings() Workbooks.
Thanks for your response Sal, the problem is intermitent and doesn't prejudice against longer directories.
We have multiple sites, multiple budgets and multiple links to multiple excel files.
Note You will still be notified if there are any broken links Warning This option affects all users of the workbook.
If you choose to not update links, and not to prompt, users of the workbook will not know the data is out of date.
Lots of hyperlinks needed to be removed from your worksheet or workbook, Kutools for Excel’s Delete Hyperlinks function can help you remove the hyperlinks in a selected range, in one or multiple worksheet, in a workbook.
After installing Kutools for Excel, please do as this:（ I have a spreadsheet with thousands of links to scanned images on a Google Drive folder.