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