Difference between revisions of "Enable Ribbon Other Options"
(→Check it’s not in Disabled Items in Registry) |
(→Check it’s not in Disabled Items in Registry) |
||
Line 44: | Line 44: | ||
If there is an entry in the above registry location you will need to delete it. | If there is an entry in the above registry location you will need to delete it. | ||
− | If you do not have administrator privileges you can download and run the application referenced in '''Removing any disabled items from registry'' section. | + | If you do not have administrator privileges you can download and run the application referenced in '''Removing any disabled items from registry''' section. |
===Run the fix utility on the installation=== | ===Run the fix utility on the installation=== |
Revision as of 16:45, 4 April 2012
Contents
[hide]- 1 Steps to check when XLCubed addin does not appear after installation
- 2 Please try each step in order, checking each time if the ribbon has appeared by restarting Excel
- 2.1 XLL may not be registered
- 2.2 XLL/COM addin appears in disabled list
- 2.3 Run the fix utility on the installation
- 2.4 Are XLCubed Functions working?
- 2.5 Is there a conflict with other addins?
- 2.6 Are other addins also disabled?
- 2.7 Visual Basic for Applications Office component not installed
- 2.8 Removing any disabled items from registry
Steps to check when XLCubed addin does not appear after installation
Please try each step in order, checking each time if the ribbon has appeared by restarting Excel
XLL may not be registered
Solution:
The following command should be run to register XLCubed assemblies:
Windows Start button, Run "C:\Program Files\XLCubedLtd\XLCubed\XLCubed.Excel.Installer.Utility.exe" /reg
XLL/COM addin appears in disabled list
Check it’s not in Disabled Items in Excel
1. Select File, Options, Add-Ins as below:
2. Select Manage, Disabled Items from the drop down and Go.
3. If there are any Disabled Items they will appear in the following window.
4. You will have to select, enable and close this window before restarting Excel.
Check it’s not in Disabled Items in Registry
Check it’s not appearing as a disabled item in the registry. Sometimes Excel may not list it as disabled item even though it is disabled in the Registry.
Look in the following 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:
- Office XP – 10.0
- Office 2003 - 11.0
- Office 2007 - 12.0
- Office 2010 - 14.0
If there is an entry in the above registry location you will need to delete it.
If you do not have administrator privileges you can download and run the application referenced in Removing any disabled items from registry section.
Run the fix utility on the installation
Run command: "C:\Program Files\XLCubed Ltd\XLCubed\XLCubed.Excel.Installer.Utility.exe" /fix
Are XLCubed Functions working?
Open the Excel workbook, put =XL3Lookup in any cell and click anywhere. If #NAME? appears where you entered =XL3Lookup that means the functions are also not working. If there is a number in that location it means that XLCubed functions are working but the ribbon is not loading.
Is there a conflict with other addins?
Untick them all – then tick each, one by one, till you find the one that is conflicting with XLCubed.
Are other addins also disabled?
Enable all other add-ins that are disabled.
Visual Basic for Applications Office component not installed
If this is not installed neither functions nor the ribbon/menu will work.
Solution:
1. Go to Control Panel, Add/Remove Programs and select the entry for Microsoft Office.
2. Change, Add or remove Features.
3. Office Shared Features, Visual Basic for Applications – make sure there is not a cross against Visual Basic for Applications
Removing any disabled items from registry
Download & run the application from:
http://www.xlcubed.com/downloads/RemoveAllDisabledItems.zip
It will pop up a console window and then proceed to delete any disabled add-in entries in registry.