Form Controls stop working after December 2014 Updates (Updated March 10, 2015)

For some users, Form Controls (FM20.dll) are no longer working as expected after installing MS14-082 Microsoft Office Security Updates for December 2014. Issues are experienced at times such as when they open files with existing VBA projects using forms controls, try to insert a forms control in to a new worksheet or run third party software that may…


Excel Crashes When You Enter Data in a Cell

We want to bring an emerging issue to your attention. We have found that in certain circumstances, Excel will crash when you type data into a cell and press <Enter>. The same crash may occur when you select data and click the Quick Analysis button. We are currently investigating the issue, but it has been…

102

"We couldn’t free up space on the Clipboard. Another program might be using it right now." [Updated 2/1/2013]

By Anita Oakley Hello everyone, we want to bring an emerging issue to your attention today. We have seen several reports of the error below in Microsoft Excel: This occurs in multiple versions of Excel when you either cut and paste cells or drag them to move the contents from one location to another. (Updated)…


The Definitive ‘Locked File’ Post (updated 8/23/2017)

Any veteran of Excel has probably seen the error very similar to the one below:   File in Use   Tester123.xlsx is locked for editing   by ‘another user’. Open ‘Read-Only’ or, click ‘Notify’ to open read-only and receive notification when the document is no longer in use. Example: Dealing with this can give anyone…


"Excel cannot complete this task with available resources" after installing MS12-030 (updated)

After you install MS12-030 (Vulnerabilities in Microsoft Excel could allow remote code execution – http://support.microsoft.com/kb/2663830) you may see the following error message appear when trying to do sorts in your spreadsheet: “Excel cannot complete this task with available resources. Choose less data or close other applications.” Updated – 6/28/2012 – a fix for this problem…


What can cause slow copy and paste in Excel?

Normally copy/paste operations in Excel are pretty instantaneous. You copy data from one place and then paste into a cell in Excel. Pretty straightforward. But what do you do if you notice that copy/paste seems to take an excesseively long time when doing a paste in Excel? There are several things you can look for…


Updated! Excel 2013 crashes when you attempt to scroll down the page

Hello everyone We have seen several reports of Excel crashing when you scroll down, even on a brand-new sheet. The Application Event log points to a crash in OSF.dll. We have found that at least one cause of this particular crash is a conflict with Avast! Antivirus. Essentially, if you install Avast! and then open any…

33

"Unspecified Automation Error" after applying MS12-060 (updated 9/26)

This article applies to Word, Access, Excel and PowerPoint. MS12-060 is a security update that was released Tuesday, August 14, 2012. This update replaced MS12-027. You may now be seeing one of the following errors: “Unspecified Automation Error” when running or compiling your Microsoft Office VBA code after installing MS12-060; or “Errors were detected while saving…


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…