Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
C
clevel
August 6, 2019
Question

Exporting Reports

  • August 6, 2019
  • 1 reply
  • 4 views
I was able to export reports to excel (.xls) up until about 2 weeks ago. My only option now is .csv. I uninstalled excel (office 365) and reinstalled. I uninstalled QB desktop and reinstalled. I checked with QB support who only sent me an article and was of no help. I am by no means a technical person but, this shouldn't be this difficult. What can I do to make this work again?

1 reply

J
JonpriL
Level 9
August 6, 2019

Hello there, @clevel!

 

Let's update your User Account Control (UAC) settings for Windows so you can successfully export your reports to MS Excel.

 

But before following the steps outlined below, your Microsoft Office 365 software needs to be locally installed on your computer. And then, you've already installed the latest version released for your QuickBooks Desktop.

 

Nevertheless, here's how so can update your UAC settings:

  1. Go to Windows Start.
  2. Type in Control Panel on the search field and press Enter.
  3. Under View by, select Large icons.
  4. Choose User Accounts.
  5. Hit Change User Account Control Settings.
  6. Move the slider to Never Notify.
  7. Click OK.

Once completed, you'll need to restart your computer so that your configuration will take effect. Also, here's an article you can read to learn more about the steps: Export Option for Excel is Grayed Out.

 

As always, you can visit our Help Articles page for QuickBooks Desktop if in case you need some tips and related articles for future use.

 

If there's anything else that I can help you with, please let me know in the comment section below. I'll be always around ready to help.

C
clevelAuthor
August 6, 2019
I have done all of that. That is the same article your "support" gave me before. Microsoft Office is installed directly on my laptop....just as it always has. I have my own unique license number for it. Nothing works!
K
KhimG
Level 7
August 6, 2019

Thanks for getting back to us and providing an update of the issue you’re experiencing, @clevel.

 

A damage Excel installation or a corrupt company file is likely the reason behind the option no longer working.

 

Let’s first run the Verify and Rebuild Utility Tool to fix any integrity issues on the file. Always create a backup to avoid any accidental data loss before performing the following steps.

 

Here’s how:

  1. Go to the File menu.
  2. Select Utilities, then Rebuild Data.
  3. Click OK on the QuickBooks Information window. 
  4. Follow the prompt to save a backup.
  5. Hit OK when you see Rebuild has completed.

You can follow the steps above except choose verify instead of rebuild. Check out this article for reference: Resolve data damage. In the same link, you’ll find other data damage troubleshooting steps for Windows.

 

Right after, try closing the Excel app through Task Manager. It might be running in the background for multiple times which is causing this unusual behavior.

  1. On your keyboard, press Ctrl + Alt + Delete.
  2. Select Excel.exe on the Processes tab.
  3. Click End Process.

Then, repair MS Excel to resolve the possible installation damage. Check out the Microsoft site for information and instructions: https://support.office.com/.

 

Reach out to me if you need further assistance. I’m always here and ready to help. Take care!

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement