You need to look at the load setting for Smartview. Its a common issue you are experiencing.
To enable the Smart View addin to display when opening Excel:
Open your registry editor. To do this, open your Windows Start menu and type “regedit”.
Go to HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins\Hyperion.CommonAddin. Ensure the LoadBehavior is set to 3.
If the LoadBehavior is anything other than “3” then follow these steps:
a. Close Excel. Make sure the “excel.exe” process is not running in the Windows Task Manager.
b. Open the registry editor again. Double-click the registry key to edit it.
c. Change the Load Behavior to “3.” Close the registry editor.
d. Re-open the registry editor to ensure “3” is still there.
- Open Excel. The Smart View add-in should now load automatically at startup.