Sage 100 Excel button is disabled or cannot export to Excel
Cause
- Role Maintenance prevents the Export to Excel from Lookup/Grids
- Microsoft Excel is not recognized by the Sage 100 program as installed on the workstation.
- More than one version of Microsoft Excel or Microsoft Office installed.
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 3:
- Check Control Panel, Programs and Features (Add/Remove Programs, etc.) for more than one entry for Microsoft Office or Excel.
- For example: Microsoft Microsoft 365 ProPlus – en-us AND Microsofot Microsoft 365 en-us.
- Compare to other working workstations regarding the “correct” entry.
Other possible resolutions:
- Verify the local ‘Users’ group has READ permissions to the following registry key:
*HKEY_CLASSES_ROOT\WOW6432Node\CLSID\{00020810-0000-0000-C000-000000000046} - Try uninstall and reinstall of the Sage 100 Workstation Setup program
- 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.
- If familiar with what registry entries are created when Microsoft Excel is installed, verify them.