The Analytics Edge add-ins are installed and should appear in Excel’s ribbon bar when you next open Microsoft Excel. If they do not, there could be several reasons. Analytics Edge can be installed in lock-down corporate environments and other non-standard environments, but you will need to manually install it (instructions below).
If you can install the add-in, but can’t Register, verify that the add-in is not being blocked for internet access by your anti-virus or personal firewall software!
! If you get an error about the Ribbon/COM Addin handler, follow steps 1 and 2 below. Restart Excel and everything should work. If that does not fix it, then open Excel File – Options dialog, navigate to Trust Center – Trust Center Settings… button navigate to Add-ins, and UNcheck the entry to Require Application Add-ins to be signed by Trusted Publisher.
! If you have followed all of the above instructions and the Analytics Edge ribbon item still does not appear in Excel, or if it stops responding, check the following:
1. Excel Has DISABLED the Add-in
Open File – Options – Addins dialog
Select the VERY LAST OPTION: Manage Disabled Items – Go…
If Analytics Edge is listed in the dialog, select it and click the Enable button.
2. Excel Has UNCHECKED the Add-in
Open the File – Options – Addins dialog
Select Manage Excel Add-ins – Go…
Make sure the Analytics Edge Add-in is checked
Advanced Installation Notes
3. Installation Folder Location
If you installed the application on a network drive or network-mapped drive, try installing it on the local hard drive instead. This applies to home folders (My Documents) that have been mapped to a network folder by your I.T. group. Create a folder on the local C: drive if you can, and install the software there.
If you are using a Mac with Windows-emulation software like Parallels, do not install on a folder in a “mapped” drive — i.e. one that is accessible to both the Mac and PC operating systems. Alternatively, turn off the option to map the drive between systems.
The application must be able to write to the file folder in order to operate, so make sure you have not installed it to a location that it write-protected.
Analytics Edge will be writing other files into the folder to keep track of licenses and various configuration settings, so it is best to use a dedicated folder just for the application. Should they become intermixed, all Analytics Edge files start with “ae” or “AnalyticsEdge”.
4. Internet Access
The product requires internet access to initialize the registration process. If you have installed personal firewall software, make sure that it is not blocking the application. Try temporarily turning it off to see if that fixes things, then investigate the settings required to operate it safely.
5. AntiVirus Software
Some antivirus software prevents any installed application from operating unless authorized. Try temporarily disabling the antivirus to see if the application works, then investigate the settings required to enable it safely.
6. 32-bit Versus 64-bit Version
Most people are surprised to discover that Microsoft installs a 32-bit version of Office by default on their brand new 64-bit Windows computer! The Analytics Edge add-in you use must match the version of Excel, not Windows, so try the 32-bit version first!
7. Use AnalyticsEdge-##bit.xll, Not aeBasic.xlsb
The add-in is contained in one of the two XLL files, depending on the version of Excel you are running. There are other supporting files in the folder, but they are supporting files for the application and are NOT usable. None of the files in this folder should be modified by the user – they are all managed by the application itself.
8. Check Your Computer Date
Make sure the computer’s date is correct. An incorrect date make cause the application start-up processes to fail.
Manual Installation Instructions
- Download either the file AnalyticsEdgeBasic.zip for the free Basic Add-in, or AnalyticsEdgeCore.zip file for the Core Add-in.
- Extract the files to a folder on your hard drive (right-click and select Extract All… from the pop-up menu).
- Open Microsoft Excel 2007, 2010, 2013 or 2016 on a Windows computer.
- Open the Excel Options (File – Options) dialog.
- Select Add-ins and click the Go… button
- Click the Browse… button
- Locate the files you unzipped in step 2 and select the AnalyticsEdgeBasic-32bit file (or AnalyticsEdgeBasic-64bit). NOTE: If one does not work, try the other.
- Click Open, and click OK to close the dialog.
The Analytics Edge ribbon should now appear in Excel.