2.5 Upgrade Core Add-in

Analytics Edge Core Add-in: Simple Upgrade

The latest release of the Core Add-in is v10.3.1, released 2021-07-02 To upgrade, simply download and run the installer. No need to uninstall the previous release.
Use the installer AnalyticsEdgeCoreInstaller.exe, or the zip file for manual installations AnalyticsEdgeCore.zip

Your License and account configuration settings will not be affected.

What’s New – v10.3.1

  • fixed a problem where the new macro name would not appear until a function was added

Problems / Feedback

All Analytics Edge paid products are supported by direct, confidential email. If you encounter a problem or have any feedback, please email support@analyticsedge.com

Previous in v10.2.0

  • fixed quirks when switching between workbooks
  • fixed writing results with a header row but no data rows
  • fixed problem with dynamically modified queries or macros not picking up changes during refresh all or VBA run
  • changed Edit Mode so it doesn’t turn itself off automatically so often
  • fixed a problem with queries in memory out of sync with contents of query sheet
  • fixed a problem with many wizards with multiple selections not selecting items scrolled out of view
  • stopped license update notices from popping up behind Excel splash screen
  • moved interactive (run once)/query/macro mode selection to ribbon to eliminate a popup
  • added ability to save interactive function as macro
  • improved responsiveness for some cancellation requests
  • fixed a problem with Total function option to remove selected columns
  • fixed a problem handling date columns from Google Sheets
  • fixed a problem with some combinations of options in the Group function
  • fixed some quirks when working with the Task Pane
  • improved error handling
  • fixed auto-activation for newly updated connectors
  • added option to not clear existing data on worksheet (overwrite)
  • added P25 and P75 aggregations to Combine, Duplicates, Lookup, Pivot, Subtotal and Total functions (25 percent of values are greater than, 75 percent of values are greater than)
  • fixed problems with managing and auto-refreshing saved Google accounts
  • fixes problem not clearing previous data when writing without header row
  • fixes ‘Cannot run commands while editing a cell’ messages in error
  • fixes macro call from worksheet button; fixes Cancel button problems
  • stability update; fixes ‘disposed object’ errors
  • more responsive cancellation
  • added runSilent and runAll options to VBA AnalyticsEdge.Runmacro function
  • fixed update dropping premium license selection
  • fixed copy/paste problem with certain macro function selections
  • New Terms of Use; requires email to activate (privacy policy)
  • Added new One Time function capability (details)
  • Added ‘if’ criteria to Run Macro/Command function (details)
  • Arrange > Insert can now insert a column of row numbers (details)
  • Notes (comments) now possible in most function wizards (details)
  • Convert wizard now supports multiple field selection (details)
  • Updated Google account login wizard
  • Simplified several function wizards
  • Overhaul of License wizard

Previously in v9

  • 9.5.1 Fixes a problem with the Convert wizard, text-to-date options
  • 9.5.0 ReadTextFile now reads JSON files as exported by Big Query
  • 9.5.0 adds UnixTimestamp to Convert options for dates
  • 9.5.0 fixes a problem with the Arrange > Insert by position and Delete by position
  • 9.5.0 adds a test for the internal web listener to License > About > Debug
  • 9.5.0 fixes some error handling when checking comments for quick query references
  • 9.4.0 fixes a problem with the Update wizard, and the Match option on the Append to Worksheet wizard
  • 9.3.0 allows you to use macro [range names] in the Write to Worksheet, Append to Worksheet wizards
  • 9.2.0 allows you to use macro [range names] in the Read Worksheet, Append, Combine, and Match function wizards
  • 9.1.0 fixes a backward compatibility problem with ‘Is Empty’ matches, and increases timeouts for Google API operations
  • 9.0.2 fixes a license check loop causing the add-in to freeze
  • 9.0.1 fixes handling of malformed version files and proper version detection
  • Now supports high definition monitors with scaling (update to the latest connector versions as well)
  • Requires .NET Framework 4.7.2 (required for hi-def monitor support)
  • User interface updated
    • Windows-standard OK-Cancel buttons adopted in all wizards
    • All wizards can be resized to show more content
  • Small ribbon changes to Edit Query/Edit Mode buttons for clarity
  • License wizard layout changes
    • more clearly separate add-in and connector license status
    • can enter multiple license keys without switching between panels
    • cleaned up license checking and auto-refresh
  • Calculate wizard layout improvements
  • Convert wizard layout improvements
  • Improved Google Sheet read and write operations
  • VBA or Button click can now call to macro “RefreshAll”
  • Added ability for Analytics Edge macro to Run Windows command
  • Added a number of aggregations in various functions for more consistent offerings
  • Cleaned up some error handling and obscure bugs
  • Fixed a few quirks in the Task Pane

Previously in v8

  • 8.1.6 Fixes a problem when trying to load workbooks with really old Basic Add-in formats (“!Addin not licensed aeCore” messages)
  • 8.1.5 Fixes a problem causing failure to load the add-in.
  • 8.1.3 Fixes a problem for some Free license users that causes the License wizard to open.
  • 8.1.2 Fixed an installer problem affecting 32-bit Excel installations.
  • 8.1.1 Fix to License wizard to not show EXPIRED after old connectors disabled.
  • Breaking Change to Copy to Google Sheets function. See details link above.
  • Added Read Google Sheet and Write Google Sheet functions
  • Added ability to send attachments via Gmail
  • Google accounts now managed via Options wizard
  • Many ribbon and wizard tweaks for improved usability
  • Fixed a problem with some combinations of selections in Join function

Previously in v7 and earlier

  • Fixed some minor quirks in the Task Pane when editing macros
  • Fixed a problem with 7.12.0 installer
  • Refreshes Excel PivotTables after scheduled refreshes, VBA calls to refresh, and editing quick queries
  • Simplified ribbon License button icons and label messaging
  • Auto-renews add-in and connector licenses after upgrades
  • Preserves Quick Functions after failed query edit
  • fixed licensing problem in manual installations
  • stability, improved error handling and bug fixes
  • rearranged license wizard elements and license status reporting
  • fixed license problem when Premium trial expires
  • fixed quick query append functionality
  • Better handling of errors caused by unexpected usage
  • Fixed a problem losing options settings if you switch from Premium to Free and back
  • Improved some error messages
  • Fixed problems with Top and Transpose functions when dealing with no data scenarios
  • Fixed a problem with some Filter condition options
  • Added better error handling with bad Regex filters
  • Fixed a problem with scheduled refreshes not running
  • Now validates license file can be updated properly
  • Fixed a scenario where comments would not update with the location of queries after a move
  • Fixed handling of filter expressions that start or end with spaces
  • Free license no longer shows the Functions wizard after editing a query
  • Fixed a problem with Google logins
  • Fixed some ribbon problems when switching between license types
  • Fixed some interaction problems where the add-in forgot the selected cell
  • Fixed a problem where the first task pane function, once selected, could not be unselected
  • Fixed some task pane interaction quirks
  • Fixed a problem with worksheets or range names starting with ‘ae’
  • Fixed a problem deactivating licenses when incorrect license key entered
  • Fixed conversion of workbooks not converting properly from old Basic add-in queries
  • Fixed FIPS-140-2 compliance problem
  • No longer disables some macro buttons if no data present
  • Fixed odd macro editing behaviour when switching between workbooks
  • Fixed problem with some macro names not being recognized properly
  • Fixed Google Sheets login and copy problems
  • NEW – Now skips Function Wizard if free add-in license
  • Added Valid Email test to the Filter and Group functions
  • Added Run a VBA Macro to the Run Macro function
  • Merged Basic and Standard add-in functionality into Core add-in