We wanted to bring to your attention a solution for a recent issue where our SmartConnect Excel templates stop working after applying Microsoft updates from 12/9/2014.
The typical symptom is that none of the buttons in the Excel Template will push, they appear to be static pictures.
This is caused by a Microsoft security update that was issued on 12/9/2014. These patches break any Excel customizations that have ActiveX controls, not just the eOne templates – any Excel VBA customizations that include ActiveX controls.
There are 2 ways to resolve this:
1. Uninstall the patches in Windows Programs and Features. The patch for Office 2010 is KB 2553154 and the patch for Office 2013 is KB 2726958
OR
2. Delete the MSForms.exd for Excel. This file will automatically get recreated when you launch Excel
a. To delete the MSForms.exd file, you need to browse to the c:Users[user.name]AppDataLocalTempExcel8.0 folder
b. Delete only the MSForms.exd file located in there.
c. This file is user specific, so you need to delete it from each individual users temp folder.
Please let us know if you have any questions at sales@eonesolutions.com.