Not Able to Export to Excel from QuickBooks Desktop

Not Able to Export to Excel from QuickBooks Desktop

Well, while working on QuickBooks, many times you need to export your files to MS Excel. Sometimes, in doing so you may receive an error. QuickBooks does not allow to export your information to Excel. This error may occur after updating your QuickBooks. You will be not able to export to excel from QuickBooks Desktop.

What is QuickBooks Error “Unable to export excel from QuickBooks Desktop” and how is it caused?

QuickBooks sometimes is unable to export files to Excel. This may be caused because your software might not be able to recognize Excel that is installed in your desktop or if you have updated QuickBooks, the installation may not be perfect or corrupted.

The other possible errors may be:

  1. Damaged MS Excel.
  2. Damaged QuickBooks.
  3. Improper installation of QuickBooks update.
  4. Your file registry may not be working properly.

How to solve QuickBooks Unable to export to Excel error?

  • Reboot the computer If QuickBooks is unable to recognize the MS Excel installed in your computer, restart your computer and then try again. Rebooting the computer may resolve the error.
  • Export as .csv file-
  1. Open the Customer Centre.
  2. Locate the Transaction in transaction panel.
  3. Now, select the transaction journal.
  4. Select the excel button and then select create new worksheet.
  5. Click on create comma separated values (.csv) file.
  6. Click Export and Save the file with the specific name you want.

You May Also Read: How to Fix QuickBooks Premier Company File Error 6123

  • Turn off User Account Control in Windows-
  1. Firstly, open Control Panel.
  2. Select User Accounts.
  3. Click on Change User Control Settings.
  4. Select Never Notify and then Click OK.
  5. Restart your computer.
  6. Open your company file.
  7. Go to Reports and Select a Report.
  8. In the report, Select Export Option. All the export option will be available.
  • Repair QuickBooks or perform clean installation- Sometimes, while updating updates may not be installed properly. It’s better to just reinstall QuickBooks Desktop.
  1. Close QuickBooks Desktop.
  2. Open Control Panel, Go to Programs and Features.
  3. Search for QuickBooks and select uninstall.
  4. Reinstall QuickBooks Desktop from the CD or .exe file.
  5. Try opening the file again. Hopefully, the error gets resolved.
  • Repair or Reinstall MS Excel- This error may occur if the MS Excel running in your desktop gets corrupted.
  1. Open Control Panel, Go to Programs and Features.
  2. Search for MS Office and select uninstall. (Note: Uninstalling MS Office will require your credentials to log in again.)
  3. Reinstall MS Office from the CD or Windows Store.
  4. Open QuickBooks and try again.

By following the above procedures, you will be able to find a solution to your problem. If you need any further assistance, you can always contact QB Premier Support at our QuickBooks premier support phone number 1-808-374-3003 before trying to solve the error manually. QuickBooks contains all your necessary data and it’s better not to take risks. They provide a 24*7 Online Customer Support Helpline facilities.

Summary
Article Name
Not Able to Export to Excel from QuickBooks Desktop - Support Solution
Description
QuickBooks sometimes Not Able to Export to Excel from QuickBooks Desktop. This may be caused because your software might not be able to recognize Excel that is installed in your desktop
Author
Publisher Name
Qbpremiersupport
Publisher Logo