If you have an add-in that you want to use in Excel, but not every time you start the program, you can exclude it from loading at start-up. This is helpful if the add-in is only needed occasionally, or if it's causing problems with Excel.
To exclude an add-in from loading at start-up:
- Open the Registry Editor by pressing Windows+R, typing
regedit, and pressing Enter. If you're prompted for permission to continue, click Yes.
- In the Registry Editor, go to
HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Excel\Options. (If you're using a different version of Office, go to HKEY_CURRENT_USER\Software\Microsoft\Office\<version>\Excel\Options, where <version> is the version number of Office, such as 15.0. If you're using a 64-bit version of Office, there will also be a key at HKEY_CURRENT_USER\Software\Wow6432Node\Microsoft\Office\16.0\Excel\Options)
- In the left pane of the Registry Editor, right-click the
Options key and select New > DWORD (32-bit) Value.
(Optional) Enter a name for the new value. This can be anything that will help you remember what the value is for.
(Optional) Double-click the new value and enter a value data of 1. This will cause Excel to always load the add-in, even if it's not listed in the Startup folder.
To include an add-in that was previously excluded:
- (Optional) Delete any values that you created in step 4.
- (Optional) Close and reopen Excel.
