Paste the above procedure into the large white area that is the workbook module, then press Alt+Q to return to the worksheet.
![how to disable links in excel 2010 how to disable links in excel 2010](https://contexturesblog.com/wp-content/uploads/2010/12/hyperlinkextract01.png)
In Excel versions 2007 or after, from your worksheet press Alt+F11, then press Ctrl+R, find your workbook name in the “Project – VBAProject” left vertical pane, expand the Microsoft Excel Object folder for your workbook, right-click on ThisWorkbook and left-click to select View Code. Right click on that icon, and left click on View Code. To easily access your workbook module, in Excel versions 2003 or before, find the little Excel workbook icon near the upper left corner of your workbook window, usually just to the immediate left of the File menu option. Workbook.Open Filename:="C\Your\File\Path\YourFileName.xls"įilename:="C\Your\File\Path\YourFileName.xls", UpdateLinks:=0ġ Updates external references only, not remote references.Ģ Updates remote references only, not external references.ģ Updates both remote and external references. Or if you want to disable the prompt before your macro opens your workbook, and enable it immediately thereafter, put this in your macro: Application.AskToUpdateLinks = False
#HOW TO DISABLE LINKS IN EXCEL 2010 UPDATE#
…In versions 2007 or after: Click the Office button or File tab > Options > scroll to the General section and select Ask to update automatic links. …In versions 2003 or before: Tools > Options > Edit > select Ask to update automatic links. To automatically update links sans VBA, if the work being done is always on your computer… You’ve no doubt seen this pop-up message upon opening a workbook: Tom’s Tutorials For Excel: Updating Links (or Not)