Excel button is disabled in ALE Lookup List windows; cannot export to Excel

Sage 100 – Excel button is disabled in ALE Lookup List windows; cannot export to Excel

Description

Excel button is disabled in ALE (Advanced Lookup Engine) Lookup List windows in Sage 100; cannot export to Excel. This is workstation specific and affects all ALE Lookups.
Example: Open Accounts Payable, Main menu, Vendor Maintenance and click the Vendor No. lookup to access the Vendor List

Disclaimer

Operating System Warning
This solution requires advanced knowledge of your computer’s operating system. Contact your system administrator for assistance. Modifying your Windows Registry incorrectly can severely affect system operations. Sage is not responsible for operation issues caused by incorrectly modifying your Windows Registry. Always create a backup of your data before proceeding with advanced solutions.

Cause

  • Microsoft Excel is not recognized by the Sage 100 program as installed on the workstation.
  • Role Maintenance prevents the Export to Excel from Lookup/Grids.

Resolution

Possible Resolution 1:

  • Select in Sage 100, Library Master, Main, Role Maintenance
    • Check the checkbox under Module Options, Library Master, Allow Export to Excel from Lookups/Grids

Possible Resolution 2:

  • Verify the following registry entry is present on the computer: HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Wow6432Node\CLSID\{00020810-0000-0000-C000-000000000046} with the data of (without the quotes): “Microsoft Excel 95 Worksheet”. If this is missing then copy it from another workstation
    • Note: In at least two cases where the key did exist, editing the “Microsoft Excel 95 Worksheet” by typing over the existing text, then saving, resolved the issue.
    •  Note: This is a dated resolution. It may not work, or the key may be different due to newer versions of Microsoft Office/Excel.

Other possible resolutions:

  •  Try uninstall and reinstall of the Sage 100 Workstation Setup programs
  •  Try uninstall and reinstall of the Microsoft Excel program
    • Note: This has been known to work because it resets the Windows Registry entry for Microsoft Office/Excel, which may be incorrect or corrupted. You may also consider running a reputable registry cleaner (after first making a backup!) prior to reinstalling.
  • Try running Sage 100 in Windows XP Compatibility mode (and also try not running it in Windows XP Compatibility mode)
  •  If familiar with what registry entries are created when Microsoft Excel is installed, verify them.

Support

If necessary, seek the assistance of Acute Data Systems to help provide assistance with this process.