Question

Excel import error. Unable to import if spreadsheet is saved to network but able to if saved locally.

Forum|Forum|4 years ago
September 20, 2021
3 replies
19 views

I 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?

QuickBooks Desktop

RenjolynC

Level 9

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:

Your version of Microsoft Office isn't compatible
Need to repair the Microsoft Office.
The User Account Control Settings is blocking the export feature.

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:

Go to the Reports menu and open any report on the list.
Select the Excel button.

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.

R

Robert412Author

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.

C

Catherine_B

Level 9

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:

Open your QuickBooks and open a specific report.
Go to the Excel button.
Select Update Existing Worksheet.
Click the Browse button to look for your existing worksheet.
Select Export.

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.

Click Help at the top menu and select QuickBooks Desktop Help.
Select Contact us and then enter that you get Reminder prompts.
Select Continue.
Choose either to Message an Agent or Talk to a Specialist.

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!

Sign up

Login with SSO

Let's get you signed in

Login with SSO