Was this page helpful?
Thank you!

Comments or suggestions?



Enter Email Address (optional)
email

QuickBooks tab missing after exporting to excel

After exporting a report to Excel the "QuickBooks" tab is missing and you can't update the report.

Detailed instructions

 

Solution 1: Enable the Add On
  1. Make sure QBexcel2003reportupdater.dll and QBexcel2007reportupdater.dll are both enabled under add-ins.
    • For Office 2007:  click on file > then click on excel options at the bottom > and then choose add-ins.
    • For Office 2010:  click on file > then click on options > and then add-ins.
      1. On lower part of Add-ins window click on Drop Down for Manage and select "COM Add-in"
      2. look for files listed above (C:\Program Files\Common Files\Intuit\QuickBooks\...) (if not listed in window)
      3. Make sure both files are Check Marked on "COM Add-Ins
         
  2. Close Excel and export your report again.
  3. You should now see the QuickBooks tab and have the ability to update the report.

** Please note:  If updating the report for the first time you must be signed into the company file as administrator.  **

 

Solution 2: Repair Excel and QuickBooks

  1. Run a repair on Excel.
  2. Reboot computer.
  3. Run a repair on QuickBooks.
  4. Reboot computer.
  5. Export a report to Excel and attempt to update the report.
  6. You should now see the QuickBooks tab and have the ability to update the report.

 

KB ID# HOW19181
12/4/2016 4:28:28 PM
PPRDQSSWS404 9138 Pro 2017 c02c5e