Basic, Standard, Core Add-in Compatibility

Analytics Edge add-ins are designed to be compatible with each other, so you can create a workbook with the Basic Add-in and refresh it with the Standard or Core Add-in. It is actually possible to create workbooks with the Core or Standard Add-in that can be refreshed with the Basic add-in BUT you can’t use any of the exclusive functions only available in the higher add-in.

Analytics Edge Basic Add-in <-> Standard Add-in

If you have upgraded to the Analytics Edge Standard Add-in, you can still emulate the behaviour of the free Basic Add-in AND produce compatible workbooks!  Quick and Easy! Simply do NOT use any of the Pivot, Arrange, Sort or Filter options available only in the Standard Add-in.

When the Functions wizard pops up, click the Write to Worksheet button. Do no use any of the other options in the wizard.

Analytics Edge Basic Add-in <->  Core Add-in

Compatibility with the Core Add-in is also possible, but there is another restriction: no macros!

Only Quick Queries are compatible, and like with the Standard Add-in, when the Functions wizard pops up, click the Write to Worksheet button.

Analytics Edge Standard Add-in <->  Core Add-in

The Core Add-in’s Quick Queries are 100% compatible with the Standard Add-in, including all the functions in the pop up Functions wizard. The Standard Add-in cannot run macros.