If you administer computers in a Domain environment you can use Group Policies and the Office 2016 ADMX file to disable trusted documents and macros, reference.
Enable hyperlinks in excel 2016 install#
In our case we want to install the add in, so click BROWSE. We can select the Addins we want to activate. A new dialog box will open as shown in the picture containing all the EXCEL ADD-INS list. The steps outlined above should work on the previous version of Excel (2010, 2013) but may vary slightly. Go to OPTIONS>ADDINS Select EXCEL ADD-INS Click GO. Set-Location "HKCU:\Software\Microsoft\Office\16.0\Excel\Security\Trusted Documents\TrustRecords" #PowerShell script to clear the Excel Trusted Documents cache The script does not require administrative privileges to run. Here is a PowerShell script to delete all the Trusted Document subkeys.
![enable hyperlinks in excel 2016 enable hyperlinks in excel 2016](https://www.howtogeek.com/wp-content/uploads/2017/01/06_removing_single_hyperlink.png)
I had other links or references that were hidden and the only way the add-in would delete them is if when opening the workbook, I had to ask Excel to try to open each file since it would prompt me as to whether I wanted to continue with these links or not. HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Excel\Security\Trusted Documents\TrustRecords It worked fine on my files that were listed under Data/Edit Links. Previously Trusted Documents are stored in the registry at the following location. PowerShell Script to clear Excel’s Trusted Documents list Click OK to save the changes and close the Trust Center settings dialog.Click the radio button next to Disable all macros without notification.Disable Macros and the Enable Macros warning ribbon
Enable hyperlinks in excel 2016 how to#
Next, we will look at how to disable macros altogether. It’s important to note that this checkbox does not disable macro or the Enable Macros warning. If you want to disable Excel from tracking and marking files as Trusted you can do so by clicking the Disable Trusted Documents checkbox. The next time you open one of those files the Enable Macros warning ribbon will be presented. Delete the key or use a value of 0 to enable the. Enter 1 as the Value data to disable the warning. Type (or paste) DisableHyperlinkWarning as the Value name then double click on it. Right click on Security key and choose New, DWORD.
![enable hyperlinks in excel 2016 enable hyperlinks in excel 2016](https://i1.wp.com/www.myofficetricks.com/wp-content/uploads/2019/09/090919_0923_HowtoTurnOf1.png)
Press Ctrl+O to get to the File | Open screen and choose Options from the left menu.
![enable hyperlinks in excel 2016 enable hyperlinks in excel 2016](https://d13ot9o61jdzpp.cloudfront.net/images/hyperlink_buttons_1.png)
Excel keeps track of documents that you have intentionally enabled macros on in the Trusted Documents list. If you choose the enable macros the file will be marked as a trusted document and each subsequent time you open the file macros are enabled automatically. The first time you open an excel workbook that has macros you are prompted with warning ribbon to enable macros.