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.

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!

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.