Error: Error opening export: External table is not in the expected format - when exporting Excel

When exporting any report from Financial Edge or Raiser's Edge you may receive the following Error: External table is not the expected format. This may occur when exporting to Excel from reports, queries, or activity grids in Financial Edge.
Update: Microsoft has identified this as an issue with recent updates and they are working to resolve it.
Installing these updates may cause applications based on the Microsoft JET Database Engine (Microsoft Access 2007 and older or non-Microsoft applications) to fail when creating or opening Microsoft Excel .xls files. The error message is, “Unexpected error from external database driver (1). (Microsoft JET Database Engine)".


Microsoft is working on a resolution and will provide an update in an upcoming release.  More details can be found in the links below for each update: Note: We provide links to third-party websites in an effort to help you resolve your issue.  We are not responsible for the information on third-party websites and we cannot assist with implementing resolutions from these websites.

Until Microsoft releases a fix, it's possible to uninstall these Windows updates from any affected workstations:
  1. Go to Start > Control Panel
  2. Under Programs click Uninstall a program
  3. Click View installed updates on the left side of the window.
  4. This displays all updates installed on the system.
  5. Locate the update(s) (KB4041681 & KB4041678 for Windows 7/Windows Server 2008 R2, KB4041693 for Window 8.1/Windows Server 2012 R2, or KB4041676 for Windows 10), right-click it and select uninstall from the menu.
  6. This removes the update from the system.
  7. Reboot the workstation.

In some situations, exporting in the CSV format can serve as an alternative solution:
  1. Go to File > Export
  2. Select the Comma Separate Values (CSV) format

Steps to Duplicate

Steps to duplicate:

1. Navigate to any report
2. Preview the report
3. Click the export icon at the top tool bar
4. Receive error: Error opening export: External table is not in the expected format -

Environment

 Financial Edge

Was this article helpful?