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: Label your X-Axis with more than one identifier
Viewed 2521 times since Tue, Oct 6, 2009
CR: Background on out-of-control test rules
Viewed 2298 times since Fri, Nov 9, 2007
CR: A custom query for Length of Stay data
Viewed 2511 times since Fri, Nov 9, 2007
CR: Charts with large amounts of data
Viewed 1914 times since Fri, Nov 9, 2007
CR: Formatting an Excel Date
Viewed 2450 times since Fri, Nov 9, 2007
CR: Excel tips
Viewed 3020 times since Tue, Oct 6, 2009
CR: Time Display
Viewed 2075 times since Fri, Nov 9, 2007
CR: CR1.1 - Notes and Causes Problem
Viewed 2087 times since Fri, Nov 9, 2007
CR: CR1.1 - Charts in the Chart Workspace do not print all of the charts
Viewed 2044 times since Fri, Nov 9, 2007
CR: Histogram bars beyond specification lines
Viewed 2314 times since Fri, Nov 9, 2007