Deriscope

The Excel Derivatives Periscope

Troubleshooting

Sometimes Deriscope fails to load properly during startup, either by the ribbon Deriscope tab not showing up or by a noticable failure occurring after clicking on the Load Deriscope button inside that ribbon tab.
If that happens, you must try the following in the indicated sequence:

Remedy Effort 1

Often loading failures are caused by faulty installation due to a non-updated Windows environment.
Please do the following:
1) Close Excel
2) Uninstall Deriscope through the Apps section of your Windows Settings
3) Restart your device
4) Go to the Updates section of your Windows Settings and ensure that no important system update is pending
5) Install Deriscope. Make sure you pick up the bitness that corresponds to that of your Excel installation. The bitness of your Windows installation is irrelevant here! You can find out the bitness of your Excel by opening Excel, going to the Account tab and clicking on About Excel.
6) Start Excel

Remedy Effort 2

Excel may have suppressed the loading of some critical component.
Please do the following:
1) Start Excel
2) Go to the Excel Options screen. In Office 365 this is done as follows:
3) Click on File and then on Options. Then the screen appears as below.



4) Select Add-ins from the left panel. Under Active Application Add-ins, the two Deriscope addins named DeriscopeGUI and DeriscopeXLL should appear, as shown below.



5) If anyone is missing, check if it is under the Inactive or Disabled list further below.
6) If it does, go to the Manage dropdown at the bottom and select COM Add-ins if the problem concerns the DeriscopeGUI or Excel Add-ins if the problem concerns the DeriscopeXLL.
7) Check the corresponding checkbox in order to force the reloading of the corresponding addin.
8) Restart Excel if needed.

Remedy Effort 3

Excel may have suppressed the loading of the Deriscope DLLs due to very strict security settings.
Please do the following:
1) Go to Excel Options as above and select the Trust Center tab from the left panel.
2) Examine the various settings to see if any of them may be responsible for blocking Deriscope.

Remedy Effort 4

Excel may have flagged the Deriscope addin as unsafe and "permanently" blocked its loading during startup.
Excel does so by setting a number other than 3 in the LoadBehavior of the Deriscope addin in registry.
More specifically, Excel associates with each addin a number from 0 to 3 - referred as LoadBehavior - that has the following impact on the addin's loading:



Please do the following:
1) Close Excel.
2) Type regedit in the "type here to search" input field that appears when you click on the windows icon located at the left bottom of your screen.
3) Give your consent for administrator access when a prompt appears and navigate to the folder where Excel resides. The exact location may vary, but below is a screenshot that shows the LoadBehavior location in my machine where I have Office 365 installed.



4) If you see a LoadBehavior number other than 3, change it to 3 by right-clicking on the LoadBehavior label at the left and select Modify.
5) Start Excel.

Remedy Effort 5

Same as above, but this time Excel has added an entry under the DisabledItems group of the Resiliency folder in registry.
Please do the following:
1) Close Excel.
2) Access the registry as above and navigate to the folder where Excel resides. The exact location may vary, but below is a screenshot that shows the location of the Excel/Resiliency/DisabledItems folder in my machine.



3) If you see any item inside the DisabledItems folder - other than the one called (Default) and is always there - simply delete it.
4) Start Excel.

Remedy Effort 6

Excel may be in such a bad state that only a reinstallation can bring it back to a normal functioning.
Please do the following, but make sure you have made a note of any custom-loaded Addins you may be using as you would need to reinstall them afterwards.
1) Close Excel.
2) Go to the Apps section of your Windows Settings and uninstall Deriscope
3) Go to the Apps section of your Windows Settings and uninstall Excel.
4) Restart your device.
5) Install Excel.
6) Install Deriscope.
7) Start Excel.