2.5 Upgrade Core Add-in

Analytics Edge Core Add-in: Simple Upgrade

The latest production release of the Core Add-in is v10.19.0 released 2023-11-06. To upgrade, simply download and run the installer. No need to uninstall the previous release. Use the installer from the Download page, or the ZIP file for a manual installation.

See below for a prerelease of version 11, which has an updated user interface and shares code with the new Desktop App. Caution: this release is incomplete and a major update involving a lot of new technology, so expect frequent updates.

Your License and account configuration settings will not be affected.

What’s New – v10.19.0 Production Release

  • 10.19.0 – patch to fix possible task pane problems caused by Excel update
  • 10.18.0 – BREAKING – updated permissions for Google Drive integration. All saved Google Drive/Sheets accounts will need to be refreshed (on the Options wizard).

What’s New – v11.0.4 Prerelease (20231108 incomplete)

Download AnalyticsEdgeCoreInstaller-11-0-3.exe

  • BREAKING – This release requires Windows 10 or higher, plus Microsoft .NET 6. It uses a lot of new technology.
  • Expect the v11 product to evolve with possible frequent updates and documentation lags.
  • Version 11 changes the folders where the license and configuration files are stored. It should automatically import version 10 configurations and inherit licensing from version 10. If you experience a problem, reach out to support via email. support @ analytcsedge.com
  • 11.0.4 – fixed macro corruption problem during editing / fixed Constant Contact wizards / fixed Microsoft email attachment problem
  • 11.0.3 – added Microsoft email capability to Save to PDF and Save to Workbook / fixed Microsoft Ads account wizard / fixed Facebook Insights account login / fixed Facebook Ads account problems.
  • 11.0.2 – fixed update available check / fixed Facebook login wizards / updated Append. Combine, Compare, Lookup, Match and Update wizards to allow cell references for table/worksheet / fixed GA4 wizard to sort fields in chooser / fixed Arrange by position rename / fixed reading worksheets where data does not start in first row or column / support transposing data written to Google Sheets / fixed Microsoft Ads scope selection
  • 11.0.1 – added support for grandfathered Basic licenses
  • fixed cell reference validation
  • added support to transpose data when writing to Google Sheets
  • fixed configuration folder at startup – should be Documents\AnalyticsEdgeAddin
  • update cell references after editing function in task pane
  • consitent interfaces in Append, Combine, Compare, Lookup, Match and Update with optional cell references

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.17.0 and earlier

  • 10.17.0 – Fixed cell references in Web Request wizard
  • 10.16.0 – Fixed a lock-up scenario involving range replacement with mutliple values
  • 10.15.0 – Fixed problems with the new Web Request function
  • 10.14.0 – Fixed option to not open task pane automatically
  • 10.13.0 – Added WebRequest function
  • 10.12.1 – Updated to reflect end of free Basic licenses
  • 10.11.1 – Properly returns to previous worksheet after editing a Quick Query
  • 10.11.0 – updated WriteToTextFile function to try to prevent OLE errors writing to large files
  • 10.10.0 – [skipped public release]
  • 10.9.0 – fixed a problem where Append to Worksheet was ignoring spaces in column matching
  • 10.8.6 – Gmail send errors are now reported properly and auto-retries once
  • Improved some error handling
  • 10.8.5 – Fixed a problem with not reporting some errors to the scheduler
  • 10.8.4 – Fixed a problem with Arrange function; inserting a column by row number
  • 10.8.3 – Fixed a problem causing ‘Collection was modified’ error during Refresh All
  • 10.8.2 – Fixed problem writing some dates to Google Sheets with some regional settings
  • 10.8.1 – Fixed problem writing some numbers to Google Sheets with some regional settings
  • 10.8.1 – Fixed missing WriteToWorksheet heading statement when saving as macro from interactive mode
  • Added Convert options to URL encode or URL decode text
  • License algorithm properly handles installations with multiple users
  • Properly handle incomplete data sent from connectors
  • Fixed a problem with reading date columns in Google Sheets
  • Fixed a problem when token expires accessing Google Sheets
  • Fixed a problem formatting date columns when writing to Google Sheets
  • Correctly report a problem when reading a text/web file
  • Correct handling of Google Sheets date format when copying through Write to Worksheet command
  • Fixed problem editing scheduled refreshes
  • Added date column format to Write to Google Sheets function
  • Added ability for Read Text/Web File command to pause between reads
  • Query status dialog now shows each query/macro refreshing during refresh all
  • Errors now start with query or macro identifier
  • Fixed a problem where quick query errors were not reported in RefreshAll
  • Fixed some problems with the Quick Functions wizard
  • Fixed some issues with handling expired connectors
  • Fixed a problem with the add-in not recognizing available updates
  • Fix problem with newly opened workbook not initializing properly
  • Fix problems with the task pane
  • Fixed a problem with moving cell references made in macros
  • Fixed empty workbooks asking to be saved on exit
  • Fixed quirks with Interactive mode
  • Automatically validate free license when License wizard opened
  • Fixed threading problems
  • Fixed shutdown to prevent reopening of empty workbook
  • Reduced logging of error/exception details
  • Changed license wizard to simplify free/premium selection
  • License updates now display message for 3 seconds then continue to prevent scheduled refreshes from stopping
  • Better handling of cancellation requests
  • Improved login wizard
  • Fixed a number of user interface quirks in several wizards
  • fixed a problem where the new macro name would not appear until a function was added
  • 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