Error installing PowerPivot – "This add-in requires Excel 2010"

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 must install the 64-bit version.This add-in requires that the Office Shared Features component of Microsoft…


MS12-060 re-released

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 control issue has been released to the download center. In addition, the KB articles have been updated with…


Excel crashes in VBE7.DLL running or enabling macro

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: Faulting application name: EXCEL.EXE, version: 14.0.6117.5003, time…


Excel documents using Information Rights Management (IRM) may hang when opening

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 that a new file may hang when you try to apply IRM protection after installing this security update. If you suspect…


"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…


"Date Modified" time stamps on shared Excel files stored on a network drive may not update correctly after saving and closing the file

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 Update (KB 2597161, or Excel hotfix, KB 2596991. Consider the following scenario: 1….


June cumulative updates have been released

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 a comma. Assume that you have an Information Rights Management (IRM)-protected workbook that contains a PivotChart…


How to: Repurpose a button in Excel 2007 or 2010

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. Download the Custom UI Editor for Microsoft Office from…


IRM error loading Excel 2010 workbook after installing MS12-030

After installing MS12-030, when you load an Excel workbook you may see the following error message: “This build of Microsoft Office is unsigned and cannot be trusted by a production Windows Rights Management Servicies (RMS Server). Before using Information Rights Management (IRM) in this build, specify a test RMS server.” This problem is caused by some specific…


‘Export to Microsoft Excel’ from Internet Explorer 9 does not enter the URL in the Excel web query dialog

Written by Amber Mertes Internet Explorer 9 provides additional security that limits the functionality of the ‘Export to Microsoft Excel’ option within an Internet Explorer web page. This was a security design improvement to Internet Explorer9.   Steps to reproduce the issue: 1. Open Internet Explorer 9 2. Open any web page, for example: http://www.msn.com 3. Right…