Analytics Edge makes it easy to get your data into Microsoft Excel. You can place multiple queries anywhere in your workbook as this video explains. More
This error usually occurs when the cells you referenced in a query have moved or the contents are changed. Analytics Edge connectors offer the ability to use cell references for the dates, but the references can get out of alignment if you add rows or columns in the worksheet, or if you renamed the worksheet. More
Analytics Edge has everything you need to export your Google Analytics/Universal Analytics data to Excel, Google Sheets or CSV files. This article shows how you can do it using the new Analytics Edge Desktop App, but a similar process can be followed with the Excel Add-in.
The Run Macro Function in the Analytics Edge Core Add-in lets you run other Analytics Edge macro or Excel VBA macros. This would typically be used to create a ‘master’ macro that runs through a specific sequence of other macros. With v7 of the Core Add-in, you can also trigger Excel VBA macros, which opens the door to running custom VBA code that does things Analytics Edge does not enable. More