cancel
Showing results for 
Search instead for 
Did you mean: 
clevel
Level 1

Exporting Reports

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?
5 Comments 5
JonpriL
Moderator

Exporting Reports

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.

clevel
Level 1

Exporting Reports

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!
KhimG
QuickBooks Team

Exporting Reports

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.

Rebuild 1.PNGRebuild 2.PNG

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!

clevel
Level 1

Exporting Reports

I tried all your suggestions. Nothing worked. So I called Microsoft and spent an hour on the phone with them. Excel had a problem and it is now fixed. However, I am still not able to export to .xls. I worked with Microsoft showing them the issue I was having in QB. They troubleshot with me and we could not resolve. Microsoft feels it is back to QB to troubleshoot. I feel my only option is to uninstall QB AGAIN and reinstall it to see if that makes a difference. Any other suggestions?
JessT
Moderator

Exporting Reports

You're right, clevel. Our option is to re-install your QuickBooks.

 

If you're still unable to export your report as XLS, you can choose CSV. Then, save an XLS copy of it. I would also recommend calling our phone team again, so they can take this to a different level for further investigation.

 

You can always go back to this thread if you have further questions.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us