Home » Categories » CHARTrunner

CR: Error “External table is not in the expected format” using Excel 2007 workbook

Problem:

When CHARTrunner attempts to read from an Excel 2007 XLSX workbook file, an error message that contains the words “External table is not in the expected format” is encountered.

CHARTrunner must use the ACE database engine in order to read data from files in Microsoft Office 2007 format, like the XLSX Excel workbook file.

This error stems from a bug in the ACE database engine. If the Excel 2007 workbook contains a worksheet dedicated to a single Excel chart (also called a “chart sheet”) the error occurs.

The ACE database engine is installed as part of the Microsoft Office 2007 installation. Or, if you do not have Microsoft Office 2007, the ACE database engine can be installed using the free “2007 Office System Driver: Data Connectivity Components” from Microsoft.

Microsoft has released a hotfix that corrects this error in the ACE database engine.

Solution:

If you already have Microsoft Office 2007 installed.

Follow these steps:

  1. If you have not yet installed Microsoft Office 2007 Service Pack 1 (or higher), the SP1 must be installed before applying the hotfix. The hotfix will refuse to install unless it detects SP1 components.

    Details for getting Office 2007 SP1 can be found here:
    http://support.microsoft.com/kb/949585
  2. Download the hotfix here and install it:
    http://support.microsoft.com/default.aspx?scid=kb;EN-US;968861

If you are using the “2007 Office System Driver: Data Connectivity Components”.

Customers who do not have Microsoft Office 2007 can install the free “2007 Office System Driver: Data Connectivity Components” from Microsoft. The ACE database engine is included in this install. This allows CHARTrunner to fetch data from Office 2007 file formats (like XLSX workbooks) without having to purchase Microsoft Office 2007.

Follow these steps:

  1. Download the latest “2007 Office System Driver: Data Connectivity Components” from here (link to http://www.microsoft.com/downloads/details.aspx?familyid=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en). If you previously installed the 2007 Office System Driver, uninstall it and then install from this download to ensure that you have the most recent version (currently version 2). The hotfix will not install with version 1 of the 2007 Office System Driver.
  2. Install the Data Connectivity Components SP2. The following link describes this service pack and has a download link. The hotfix will not install unless this has been installed:
    http://support.microsoft.com/default.aspx?scid=kb;EN-US;957262
  3. Download the hotfix and install it:
    http://support.microsoft.com/default.aspx?scid=kb;EN-US;968861
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
CR: Charting pass-fail data as a p-chart
Viewed 4526 times since Fri, Feb 29, 2008
CR: Background on out-of-control test rules
Viewed 2325 times since Fri, Nov 9, 2007
CR: A simple query pattern for summarizing raw data
Viewed 2960 times since Tue, Oct 6, 2009
CR: Some Excel Spreadsheet Values Seem To Be Missing
Viewed 2241 times since Fri, Nov 9, 2007
CR: CHARTrunner and SharePoint
Viewed 4046 times since Fri, Mar 9, 2012
CR: Making an X-bar chart with a single data column
Viewed 2110 times since Fri, Nov 9, 2007
CR: Largest Subgroup Size Supported by CHARTrunner
Viewed 2056 times since Fri, Nov 9, 2007
CR: CHARTrunner and Open Office
Viewed 2431 times since Fri, Nov 9, 2007
CR: Collating sequence not supported
Viewed 2693 times since Tue, Dec 11, 2007
CR: Charts with large amounts of data
Viewed 1950 times since Fri, Nov 9, 2007