ActiveX and form controls resize themselves when clicked or doing a print preview

When using ActiveX controls in Microsoft Excel 2010 you may find the controls are resizing themselves when performing various tasks. Say what??? The controls can grow in size or become smaller. Below is a step by step on how to fix the problem: 1. Install the hotfix from http://support.microsoft.com/kb/2598144. 2. Next, you need to enable…


Installations of Office 2013 may not allow COM add-ins to register successfully

By Amber Mertes With Office 2013, the Add-In Designer (msaddndr.dll) was removed. As a workaround, you may reinstall the VB6 solution for the add-in after you install Office 2013 (if the developer’s package included this DLL). Refer to “Changes in Office 2013” –  http://technet.microsoft.com/en-us/library/cc178954.aspx More information from the Office Development Team: http://blogs.msdn.com/b/vsod/archive/2012/11/21/vb6-based-add-ins-may-fail-to-work-on-office-2013.aspx Support Note: The .dll was removed…


Pivot table stripped after "unreadable content" error encountered

Pivot tables can be difficult enough to work with by themselves, but it’s even more frustrating when Excel finds unreadable content in your workbook and strips the pivot table off the sheet. You may notice this problem after you refresh data in your pivot table, save the file, close it and then try to re-open…


Microsoft Excel or Microsoft Word does not appear in DCOM Configuration snap-in

There are times when you may want to configure permissions for Excel in the DCOM configuration tool. This is a fairly straightforward process if you follow http://msdn.microsoft.com/en-us/library/ms678426(VS.85).aspx – “Setting Process-Wide Security Using DCOMCNFG”. But you may run into a problem where “Microsoft Excel Application” doesn’t appear in DCOM. Additionally, you may receive the following error when working…


October Cumulative Update has been released

It ran a bit late, but the October cumulative update has been released for Office. Below are the links: Office 2007 Cumulative Update for October 2012 – http://support.microsoft.com/kb/2757116 Office 2010 Cumulative Update for October 2012 – http://support.microsoft.com/kb/2757117