Tuesday 21 January 2014

Smart View Error "Run-Time Error '53': File not Found: HsAddin"


Symptoms

When user clicks Smart View toolbar in the Addins tab on the Ribbon the following error message appears:
Microsoft Visual Basic
Run-time error '53':
File not found: HsAddin


Cause

Smart View addin has been disabled by Excel.

Solution

First try to re-enable Smart View add-in using Excel's user interface:

Office 2003:
  1. Help -> About Microsoft Office Excel
  2. Choose Disabled Items...
  3. Select SmartView and choose Enable
Office 2007:
  1. Office Button -> Options...
  2. Select Add-Ins at the left
  3. In the Manage drop-down menu at the bottom, select Disabled Items
  4. Choose Go...
  5. Select SmartView and choose Enable
If Smart View is not listed in the Disabled Items dialog box, a Windows Registry modification will be necessary to resolve the issue.

Note:
Make sure you have a backup copy of Windows Registry, before attempting to make any changes in it.
 
In Windows Registry find following key HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Resiliency and delete the entry pointing to the HsAddin.dll:
  1. Open RegEdit
  2. Navigate to HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Resiliency
    (Note: This location refers to Office 2007. If you have Office 2003, substitute 11.0 for 12.0 above. Substitute other versions as necessary)
  3. Locate the value, which will have a random name, that points to HsAddin.dll. The path is in Unicode characters but if the path contains English or European characters can usually be identified if you double-click each value in turn -- the path can be read at the right of the dialog box. Read every other letter.
  4. Right click the value and choose Delete.
  5. Repeat for HKEY_LOCAL_MACHINE\Software\Microsoft\Office\12.0\Excel\Resiliency if it exists.


 Reference:

Smart View Error "Run-time error '53': File not found: HsAddin" when Clicking on Smart View Toolbar (Doc ID 875795.1)

6 comments:

  1. The given web page details are informative but if you want to fix runtime error 53 then you have to repair dll, registry file, restore stsrem because the error code 53 occurs if the dll file of the system is missing or corrupt so unable to found by the application or program. Dll files are the most important file of the system so thay are missing or not found then you can't run the system.

    ReplyDelete
  2. Thank you so much for this info

    ReplyDelete
  3. I am running Windows 8, 64-bit operating system, Excel 2013, there is no "Resiliency" path in regedit. Is there alternative?

    ReplyDelete
  4. Best content & valuable as well. Thanks for sharing this content.
    Approved Auditor in DAFZA
    Approved Auditor in RAKEZ
    Approved Auditor in JAFZA
    i heard about this blog & get actually whatever i was finding. Nice post love to read this blog
    Approved Auditor in DMCC

    ReplyDelete