Hello jdemo!
Welcome to QuickBooks Community! I'm here to help you and share the possible reason for this exporting behavior.
When exporting data, it'll temporarily close the existing Excel file to successfully generate the new one. It'll be restored and will automatically reopen once the new report has been exported already.
Here are the common reasons why you experienced this behavior:
- MS Office and QuickBooks versions are not compatible
- MS Office or QuickBooks installations are damaged
- There is a problem with the report or the data file itself
Each version of QuickBooks Desktop has its system requirements. We need to make sure that they are using either Microsoft Excel 2019, 2016, or 2013. For Microsoft 365, it must be installed locally and not the web version. Check for more details here: System requirements for QuickBooks Desktop 2021.
Also, please update both your Excel and QuickBooks Desktop to the latest release. We need to ensure that you have installed the new fixes and patches.
Before you export the data, I suggest you run the Verify and Rebuild Data tool. This will fix any issue on the file so that your company data is error-free.
Need to personalize the reports in QuickBooks Desktop? You can find the instructions here: Customize reports.
Keep on posting here if you have additional concerns. Take care!
