We are having an issue here with one of users. We are running quickbooks 2021 desktop enterprise. If one of our users has a Excel file open and then if he goes to export an excel file from Quickbooks, when it does the export it first will close out all excel application workbooks that are open without warning and without saving. Is there any way to avoid this from happening?
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.