General Ledger Support Document

NEMRC General Ledger Export to Excel for Office 2010 Error

NEMRC uses Excel automation to create the spreadsheets in the General Ledger custom report writer.

It appears that if Excel is installed using the Click to Run option, these functions DO NOT WORK. Below is the workaround. (Do not do this unless you are sure you have the correct login and passwords.)

You may see a NEMRC error report with the following text:
General Ledger Version - 7.9k 1733 Class definition EXCEL.APPLICATION is not found.

Click to Run installation is only available online, so must be changed through downloading a different version of Office from where your original was downloaded.

You may need a Windows Live account where your online license is located. You may need to contact your IT technician for assistance.

Use the following procedure to remove Office 2010:

If Office 2010 Click-to-Run does not meet your needs, you can uninstall it. Then, install Office 2010 by using a method other than Click-to-Run. To do this, follow these steps:

Uninstall the Click-to-Run version of Office 2010 from Control Panel. Depending on the version of Windows you have, use the Programs and Features or the Add/Remove Programs Control Panel. Select and remove Office 2010.

Visit the site where you purchased Office 2010, and sign in with the same Live ID that you used when you first purchased Office 2010.

Click the My Account link at the top of the home page to access your Office downloads.

Click the Download button for the suite that you purchased, and then click the Advanced Options link under the Download Now button.

There is a version of Office 2010 listed that is not Click-to-Run and that does not require an available Q: drive.

Additional detail at: http://support.microsoft.com/kb/982431