Use the start menu item to automatically enable the add-in.
Use these steps to check when Anaplan XL Reporting add-in doesn't appear after installation.
Important: Try each step in order, checking each time if the ribbon has appeared by restarting Excel.
Use the Enable or Disable Anaplan XL start menu item
Use the start menu item to automatically enable the add-in. See Install Anaplan XL Reporting.
XLL/COM add-in appears in the disabled list
Check it isn't in the Disabled Items in Excel
- Select File > Options > Add-Ins.
- Select Disabled Items from the Manage dropdown and the Go button. If there are any disabled items, they'll appear in the Disabled Items window.
- Select everything in the list (any disabled items will impact the other add-ins, even if it's not Anaplan XL), choose the Enable button and Close. Close the window before restarting Excel.
Check Trust Center Add-ins Options
- Select File > Options > Trust Center > Add-Ins.
- Select the Require Application Add-ins to be signed by the Trusted Publisher checkbox.
XLL may not be registered
Select the Enable or Disable Anaplan XL item in the Windows Start menu.
If this doesn't work, run the command to register Anaplan XL assemblies:
Windows Start button > Run then, depending on your computer:
"C:\Program Files\Anaplan\Anaplan XL Reporting\XLCubed.Excel.Installer.Utility.exe" /reg "C:\Program Files (x86)\Anaplan\Anaplan XL Reporting\XLCubed.Excel.Installer.Utility.exe" /reg
XLL/COM add-in is disabled, but hidden from the list
Check it isn't in the Disabled Items in Registry
Check it doesn't appear as a disabled item in the registry. Sometimes, Excel may not list it as a disabled item even though it is disabled in the Registry.
Look in the location:
HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel\Resiliency\Disabled Items
The sub-folder below Office in the above location varies depending on the version of Office. For example:
- Office 2013: 15.0
- Office 2016: 16.0
If an entry exists in the registry location above, delete it.
If you don't have administrator rights, download and run the application in Removing any disabled items from the registry section.
Excel Options registry key has a missing add-in
Look in the location below. Adjust the version number.
HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\14.0\Excel\Options
If the Anaplan XL add-in is present but is preceded by a blank or corrupted add-in, it won't load. For example, if it is present in OPEN1, but OPEN is blank, then Excel will stop loading add-ins before loading Anaplan XL.
This problem behaves in a specific way. If you add the add-in again, the ribbon will show up, but it won't load the next time Excel opens.
Check that all prerequisites are installed
See prerequisites.
Run the fix utility on the installation
Run the command as an elevated administrator:
"C:\Program Files\Anaplan\Anaplan XL Reporting\XLCubed.Excel.Installer.Utility.exe" /fix "C:\Program Files (x86)\Anaplan\Anaplan XL Reporting\XLCubed.Excel.Installer.Utility.exe" /fix
Rename your Anaplan XL settings folder
Use Explorer to browse to %appdata%\Anaplan XL, and rename the Anaplan XL Excel Edition folder.
Reboot your computer
Windows Updates and other software installations can sometimes leave software components in an unusable state until you restart the computer.
Are Anaplan XL functions working?
Open the Excel workbook, enter =XL3Lookup in any cell, and press Enter. If #NAME? appears where you entered =XL3Lookup, this means the functions are also not working. If a number appears in that location, Anaplan XL functions are working, but the ribbon isn't loading.
Is there a conflict with other add-ins?
Clear all add-ins, then enable them one at a time until you find the one that conflicts with Anaplan XL.
Are other add-ins also disabled?
Enable any other disabled add-ins.
Is the Automation Security Level too restrictive?
This usually applies only if your domain administrator manages Microsoft Office security settings via Group Policy or configured them via the Office Customization Tool.
The Automation security setting can limit the loading of the Anaplan XL ribbon if it isn't set to Macros enabled (default).
More information about this setting can be found in these TechNet articles:
- Office 2007: Security policies and settings in the 2007 Office system.
- Office 2010 and 2013: Plan security settings for VBA macros for Office
Necessary Office components not installed
If the Visual Basic for Applications and .NET Programmability Support components aren't installed, functions and the ribbon/menu may not work.
Solution:
- Go to Control Panel > Add/Remove Programs and select the Microsoft Office entry.
- Change, Add or remove Features.
- In Office Shared Features > Visual Basic for Applications, ensure there isn't a cross next to Visual Basic for Applications.
- Navigate to Microsoft Office Excel > .NET Programmability Support and ensure there isn't a cross against .NET Programmability Support.
You receive an error while processing XLCubed.dna
There was an error during processing of C:\Program Files (x86)\Anaplan\Anaplan XL Reporting\XLCubed.dna: There is an error in XML document (0, 0). The type initializer for 'System.Xml.Serialization.XmlSerializationReader' threw an exception.
Follow the instructions in the Error while processing XLCubed.dna.
