Export to Excel option is greyed out

Legacy KB ID: 4948

Question

Why is the option to export a report to Excel greyed out?  The CSV option is available.

 

Answer

You may also see an error:  Unrecoverable Error 14900 31866

Accounts Business does not recognize that Microsoft Excel is installed. Accounts Business finds Microsoft Excel by reading registry entries. If it cannot find Microsoft Excel then:

·         The user does not have sufficient permissions to read the Windows Registry;

·         Your installation of Microsoft Excel is damaged.

·         Your installation of QuickBooks is damaged.

·         Your registry is damaged. 

·         You are not using a supported version of Microsoft Office.

 

Solutions

1.    Run Accounts Business (formerly QuickBooks) with an administrator account.

i.      Close Accounts Business;

ii.     Right-click the Accounts Business desktop icon or executable file (QBwin32.exe);

iii.    Properties > Compatibility

iv.   Under Privilege level, tick run this program as an Administrator

                                          i.    If the user to this PC does not have Administrator rights, then he will have to supply an Admin username and password when prompted;

v.    Windows 7 & Vista users only:

                                          i.    Tick the box: Run this program in compatibility mode for;

                                         ii.    Select Windows XP (service pack 2) from the dropdown menu.

Launch Accounts Business and try the Export to Excel function.

 

If the problem persists, continue with the following steps until the issue is resolved.

 

2.    Repair your Microsoft Office installation. 

                      i.        Close Accounts Business and Microsoft Office;

                     ii.        Obtain your Microsoft Installation disk and Activation codes (you may need to refer to your IT professional)

                    iii.        Control Panel > Programs and Features;

                   iv.        Right-click Microsoft Office… and select Change > Repair

Open Microsoft Office and launch QuickBooks and try the Exoport to Excel function.

 

3.    Check your Microsoft Office version.

                      i.        In a Microsoft Office product click on Help > About

                     ii.        Click to Run, Trial and Starter Edition versions of Microsoft Office or Excel do not support integration with Accounts Business;

                    iii.        Install a supported version of Microsoft Office.

 

4.    Repair the Accounts Business installation. 

                      i.        Close Accounts Business;

                     ii.        Control Panel > Programs and Features;

                    iii.        Right-click ReckonAccounts Your Edition: Your Flavour 20xx and select Uninstall/Change;

                   iv.        Follow the Wizard to Repair your QuickBooks installation;

                    v.        Launch Accounts Business, open your company file and Activate.  Then test the Export to Excel function.

 

5.    The Windows Registry is corrupt - refer to your IT professional for guidance.

 

How did we do?

Bank Account BSB and Number must not be empty error when uploading to a SuperStream Clearing House

Date format changes after exporting to Excel

Related Articles

Powered by HelpDocs (opens in a new tab)

Powered by HelpDocs (opens in a new tab)