Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowI work 3rd party IT support for a company. They use Quickbooks and are getting an error when importing from an Excel spreadsheet. The error says: "This workbook has been modified. Save the workbook and try updating again." No matter how many times I save the workbook it gives that same error. I even saved a copy of the spreadsheet and tried to import from the copy but get the same error. This workbook is saved to a network file share. The company has always done the import this way. It worked last month but not this month. Same user and same network location. I was able to get it to work by saving the spreadsheet locally. Office and Quickbooks are fully up-to-date. The server and computer have been rebooted. How can I solve this so that they can import from the network share again?
Welcome to the QuickBooks Community, Robert412.
I have some details about the error and how we can fix it.
There are a few possible reasons why this is happening, and here are the following:
To resolve this issue, let's make sure that your QuickBooks Desktop is updated to the latest release.
After the update, open QuickBooks and try to export a report by following these steps:
If you're still getting the error message, please check the system requirements for your version of QuickBooks: 2017, 2018, 2019, 2020. Each version of QuickBooks Desktop works with specific versions of Microsoft Office. If the version of Microsoft Office you have isn't compatible, you'll need to upgrade.
Otherwise, repair your Microsoft Office.
Once done, go back into QuickBooks and export a report. If you're getting the same result, you can follow Step 4 and Step 5 in this article: Fix export to Excel issues in QuickBooks Desktop.
To learn more about the exporting, different reports, how to customize them, you can read these links:
Please keep me posted on how it goes. I want to make sure this is resolved for you. Take care.
Hello and thank you for the reply! This is for IMPORTING from excel to Quickbooks, not EXPORTING. Office and Quickbooks are up to date already. Like I said this process worked last month so I highly doubt it's an incompatibility.
Thanks for keeping us posted, Robert412.
A few updates often fix this issue. We wanted to ensure that the latest release you have with QuickBooks is compatible with your updated Micorsoft Office. We can try updating the existing excel worksheet within QuickBooks Desktop.
Here's how:
If the same thing happens, you can follow the steps from Microsoft to repair Microsoft Office. Then go back to QuickBooks and export a report. If you still can't, move on to Step 4 on this article: Fix export/import to Excel issues in QuickBooks Desktop.
Another option is to contact our Technical Support Team about this. They can further review the issue and provide additional steps to get it working.
Just in case you want to customize the report you generate, you can read through this article: Create, access, and modify memorized reports.
Always visit us back here if you need more help with your reports in QuickBooks. Take care and stay safe!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.