This section documents all changes and bug fixes applied to MySQL for Excel since the release of 1.2.1. Several new features were added, for more information see What Is New In MySQL for Excel 1.3.
Upgrading from versions MySQL for Excel 1.2.0 and lower is not possible due to a bug fixed in MySQL for Excel 1.2.1. In that scenario, the old version (MySQL for Excel 1.2.0 or lower) must be uninstalled first. Upgrading from version 1.2.1 works correctly.
Control + A cannot be used
to select all database objects. Either
click must be
PivotTables are normally placed to the right (skipping one column) of the imported data, they will not be created if there is another existing Excel object at that position.
Functionality Added or Changed
Imported data can now be refreshed by using the native Refresh feature. Fields in the imported data sheet are then updated against the live MySQL database using the saved connection ID.
Functionality was added to import data directly into PivotTables, which can be created from any Import operation.
Multiple objects (tables and views) can now be imported into Excel, when before only one object could be selected. Relational information is also utilized when importing multiple objects.
All options now have descriptive tooltips. Hovering over an option/preference displays helpful information about its use.
A new Export Data, Advanced Options option was added that shows all available data types in the Data Type combo box, instead of only showing a subset of the most popular data types.
The option dialogs now include a Refresh To Defaults button that resets the dialog's options to their defaults values. Each option dialog is set individually.
A new Add Summary Fields for Numeric Columns option was added to the Import Data dialog that automatically adds summary fields for numeric data after the last row of the imported data. The specific summary function is selectable from many options, such as "Total" and "Average."
A new collation option was added for the schema and table creation wizards. The default schema collation is "Server Default", and the default table collation is "Schema Default." Collation options may be selected from a drop-down list of all available collations.
MySQL for Excel would take a long time to load (minutes instead of minutes) when a large number of MySQL connections were present, such as 300. (Bug #17852222)