In some cases, third-party software that automates Excel processes, such as exporting to Excel, may cause issues with Excel and a conflict with Smart View.
To disable Smart View when Excel is started in automation mode, you may enable “DisableInAutomation” by adding a key and key value to the Windows Registry. To do this, create the Options key and DisableInAutomation key value as follows:
Key Name:
[HKEY_CURRENT_USER\Software\Oracle\SmartView\Options]
Key Value:
"DisableInAutomation"=dword:00000001
When set to 00000001, Smart View is disabled when Excel is started in automation mode. Smart View starts correctly when Excel is started manually, outside of an automated process.
When set to 0 or not created at all, then Smart View is enabled and starts when Excel is started in automation mode, which may cause issues. Smart View starts correctly when Excel is started manually, outside of an automated process.
Creating the Registry Key and Key Value
To create and update the registry key, Options:
Click Start, click Run, type regeditin the Open box, and then click OK.
Locate and then select the following registry subkey:
HKEY_CURRENT_USER\Software\Oracle\SmartView\
From the Edit menu, select New, and then select Key.
Type Options, and then press Enter.
From the Edit menu, select New, and then select DWORD Value.
Type DisableInAutomation, and then press Enter.
In the Details pane, right-click DisableInAutomation, and then click Modify.
In the Value data box, type 00000001, and then click OK.
The value, 00000001, enables the DisableInAutomation key.
Note: | If a zero value is entered, then this option is disabled. |
Exit Registry Editor.
Restart Excel.