ANALYTICS EDGE – active table in memory. See Analytics Edge Help for more information.
The Analytics Edge Core Add-in lets you download or import data from various sources, modify it using a variety of analytics function wizards, and then write the results to a Microsoft Excel worksheet.
When you are editing or stepping through an Analytics Edge macro, a worksheet will appear (AE Step Results) with the “active table in memory” message above. This temporary worksheet shows you what it is currently in memory — the results of the last function step — before you formally write it out to a worksheet.
Why does it do this?
The add-in uses a series of wizard-based functions to read and process your data. For example, you could download data in the first step, then filter it, then pivot it to get a trend, then sort it, and finally write the results to a specific location on your report worksheet.
When you run the macro, all you would see is the data refreshing in your report. But when you are developing or editing the macro, you need to see what is going on, so Analytics Edge creates a new, temporary worksheet and displays the data to you.
It also highlights the data in green to make it distinctive, and will remove the worksheet when you write your result out to another worksheet (or Run the macro, or click the square Stop button). You don’t have to worry about it — the add-in will take care of everything for you.
Note that it may not contain all of the rows and/or columns of the actual data. This is done to prevent the workbook from getting too large, and because Analytics Edge can actually process more data that Excel can handle. To see all of the results, use the Write Worksheet wizard to write it all into to your workbook.