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

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

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

Consider the following scenario: When you click a link in Excel to another Office document, you may receive an error saying "Cannot locate the internet server or proxy server." Using Bing, your search brings you to KB Article 218153 ( http://support...

After applying May 2014 Cumulative updates for Office 2013 Click-to-Run, an error occurs when refreshing an existing workbook data connection to a .bism file and/or when creating a new connection using a .bism file. The message received is: "The...

After installing MS12-030 ( http://support.microsoft.com/KB/2597166 for Excel 2010 or http://support.microsoft.com/kb/2597162 for Excel 2007) you may notice a problem with files that contain links to other spreadsheets. This problem won't happen to...

As I read through the feedback on Excel 2013, it strikes me that many users are having a little trouble getting used to the interface changes, and are not aware of options to replace the things they miss in earlier versions of Excel. So here are a few...

After editing the Internet Explorer settings via group policy, some users are experiencing errors when trying to launch the Office applications. ERROR Examples: "Word could not create the work file. Check the temp environment variable."...

When you are coding and use a compact method of referring to a pivot table such as: ActiveSheet.PivotTables(1). You would expect VBA's intellisense to display the methods and properties of the PivotTables collection when adding the period, however...

When you embed another Excel file into an Excel 2007 or 2010 workbook, choosing only to show the icon for the file, you may find that after saving the Excel workbook that the icon text, picture or both text and picture is missing. In some cases the picture...

When you create a hyperlink to another Office document in Excel 2007 or 2010 and click to follow that hyperlink, you expect the document to open. In some cases, however, you may receive an error: "Cannot locate the Internet server or proxy server". A...

By Laura Holzwarth A new security update (MS12-027) released, April 10 has been released that affects MSCOMCTL.OCX, which means this not only affects Excel, but can affect all of the Office applications including Word and Power Point. When you enable...

For Excel 2007 - http://support.microsoft.com/kb/2712234 The update fixes the following problems: Assume that an HTML file contains an integer value that has a period. When you open the HTML file by using Excel 2007, the period is replaced with...

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

Windows DevMode has a limitation of 32 characters. What this means is that printer names cannot be longer than 32 characters... 31 really. Why does it matter? When Excel queries the printers, it is given the printer name information from Windows...

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

If you've ever used ActiveX controls on your Excel Spreadsheet you may have run into the problem of the control suddenly no longer working. When you open the workbook there's nothing but a big red X in the place of where your control used to be. The tree...

In the beginning, there was KB Article 218153 - "Error message when clicking hyperlink in Office: 'Cannot locate the Internet server or proxy server' ". And it was good. This KB Article contains a registry key change that implements the 'ForceShellExecute...

Repurposing a button in Excel is incredibly easy these days. To repurpose a button means to redefine what happens when you click the button. Want it to perform some action from a custom macro? Follow the steps below to find out how this is done. 1...

If an Excel workbook in XML Spreadsheet format (*.xml) is stored as a UTF-16 Unicode text stream, you may have problems opening it in the expected program when trying to open it through Windows Explorer or Windows Internet Explorer. This problem can occur...

Table cells may be displayed in the wrong location when opening large HTML files in Excel 2003, Excel 2007, Excel 2010 or Excel 2013. This can occur if there is a <td> tag that contains a <br> with a large number of rows or cells spanning...

After installing the fix from KB article 2596596 ( http://support.microsoft.com/kb/2596596) you may find your charts are missing elements when printed. The missing elements can include chart titles, data lables and legends. They are seen on screen and...

On October 25, Microsoft released Microsoft Office 2007 Service Pack 3. KB Article 2591039 ( http://support.microsoft.com/kb/2591039) contains technical details about SP3, while 2526086 ( http://support.microsoft.com/kb/2526086) contains general information...

There are fixes aplenty for Excel in Office 2010 Service Pack 1. You can download the patch from http://support.microsoft.com/kb/2460049 . On this page you can choose to download the 32 or 64-bit version. This is dependent on the bit version of Office...

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/