Top 10 List of Performance Issues in Excel Workbooks

By Laura Holzwarth Performance issues are some of our biggest call generators. Users get frustrated with Excel when they upgrade to later versions. Performance issues often boil down to spreadsheets that have been around a long time and the design. Here are some of the common problem areas: Slow Opening: Opening an Excel file the first…


"The file you are trying to open, [filename], is in a different format than specified by the file extension" error opening Excel files

When trying to open an Excel file, you may run into the following error: “The file you are trying to open, [filename], is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trustworthy source before opening the file. Do you want to open…


File "locked for editing by ‘another user’" opening or saving file in Terminal Services environment

When trying to open or save an Excel file in a terminal services environment, you may encounter one or more of the following errors: [Filename] is locked for editing by ‘another user’ [Filename] cannot be accessd. The file may be corrupted, located on a server that is not responding, or read-only. This can also happen…


Office 2013 returns an error inserting Scriptable ActiveX controls onto a worksheet

By Amber Mertes In Excel 2013, use of certain scriptable controls on a worksheet was deprecated. You will experience errors similar to those below when trying to insert one of the controls. The change was implemented to improve security and these errors are expected. This issue affects: Web Browser ControlMicrosoft Scriptlet ComponentDHTML Editing ControlDHTML Editing…


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