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...

Thanks for the feedback the “available resources” post! We realized that many people are getting these type of memory issues in Excel and are looking for some answers. So we wrote a detailed KB that addresses most of the common memory issues...

We are seeing a few cases where the VBA component of the Office 2013 apps stop functioning. The applications are working properly when installed. Then a few days later VBA buttons no longer work. Here are the scenarios that we have seen: Access: ...

We’ve had a few reports recently from people who have built new PivotTables in Excel 2013, and when they try to reopen the book, receive a message saying: We found a problem with some content in <filename>. Do you want us to try to recover...

There are plenty of examples out on the internet to use the Open XML SDK 2.0 and Visual Studio 2010 to create Excel workbooks. I wanted to create my own how-to because the other examples I found seemed overly complex and some lacked basic information...

When you try opening an Excel 2010 PowerPivot workbook in Excel 2013 you will find that you are unable to manipulate the PivotTable. In addition, you will be prompted with an error message that asks you to upgrade the data model: However, when you...

After you install Excel 2013 or Office 2013 click-to-run and launch Excel 2013 it may crash, giving you the following error: "Microsoft Excel has stopped working". This problem can happen when the DisplayLinkManager driver is installed on the system...

By Laura Holzwarth Troubleshooting crashes in Excel be difficult. To assist you in this endeavor, we have published a two articles that walks you through a list of several methods and advanced troubleshooting steps involving hangs and crashes in Excel...

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...

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...

For those seeking out known issues with Excel Services and PowerPivot, a support blog for these products has now been released. The blog can be found here: http://blogs.technet.com/b/excel_services__powerpivot_for_sharepoint_support_blog/

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...

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...

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...

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....

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...

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...

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...

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...

When trying to install PowerPivot for Excel 2010 you may receive the following error message: Setup is missing prerequisites: This add-in requires Excel 2010. If you have 32-bit Excel, you must install the 32-bit version of the add-in. If not, you...

MS12-060 is a security update that was released Tuesday, August 14, 2012. This update replaced MS12-027. Some may be seeing "Unspecified Automation Error" when running your Microsoft Office VBA code after installing MS12-060. The fix for the MSCOM...

When attempting to run VBA code in Excel, the following error may be thrown: "File not found". When you click OK, the Visual Basic Editor (VBE) shows up and you may have to break out of the code. Or, Excel may just crash with the following error signature...

We have seen reports of Excel documents hanging whenever trying to open a spreadsheet that uses Information Rights Management (IRM) after you apply MS12-057 or this hotfix: http://support.microsoft.com/kb/2687297 . Additionally, the reports go on to say...

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...

By Dan Fox Recently, we have seen an issue with Excel 2007 where the time stamp on a shared Excel file stored on a network drive/UNC path will not update accordingly after saving and closing the file. This issue appears after installing MS12-030 Security...