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…