Reports won't export to Excel and cant be emailed in Excel format
I have QB Desktop 2017 (Enterprise Solutions / Professional Services, edition 17.0). We work in a multi-user environment on a shared server. As of today I can no longer export a report to Excel. Whether I choose "create new worksheet" or "create CSV file" it goes as far as showing the "working" box with the message "sending to excel" and the green bar that shows export progress, but then nothing else happens. Excel never opens up as it did before. The process just stops. Also, when I try to email the report in Excel format, the hourglass shows up for a seconds but then nothing happens. It never opens the email page with the report waiting to be sent. (Emailing report as PDF file DOES work however - - the issue is only with Excel). Again, this all worked yesterday. My colleague is able to export and email reports in excel with no issues. Help!
Exporting and emailing your report in Excel format is my priority. Let me help you sort this out.
To better isolate this issue, as an initial step, you may want to open a sample company file. This is to check whether this has something to do with your company file or QuickBooks Program.
If you're able to export and email the report in Excel format, we can verify and rebuild your data. The data verification process in QuickBooks is a tool that examines the health of your QuickBooks company data file.
To Verify Data:
Choose Window at the top, then Close All.
Click on Utilities.
To Rebuild Data:
Click on Utilities.
You will receive a warning message to backup your company file, press OK.
Click OKwhen you get the message "Rebuild has completed".
If not, let's try to repair your QuickBooks Desktop. See the detailed steps below:
Restart your computer to close unnecessary programs interfering with QuickBooks.
If the problems persists, you may want to reach out the Desktop Support Team. Agents have specialized tools, such as screen-sharing, to take an in depth look at your account to determine what's causing this issue. Here's how to get in touch with the team:
1. Press the F1 key on your keyboard.
2. Select Contact Us.
3. Enter Support in the field and click Continue.
4. From here you can message an agent to begin a chat session.