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

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:

1. Go to the Reports menu and open any report on the list.
2. 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: 

• Export reports as Excel workbooks in QuickBooks Desktop
• Understand reports
• Customize reports in QuickBooks Desktop

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: 

1. Open your QuickBooks and open a specific report. 
2. Go to the Excel button.
3. Select Update Existing Worksheet.
4. Click the Browse button to look for your existing worksheet.
5. 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.

1. Click Help at the top menu and select QuickBooks Desktop Help.
2. Select Contact us and then enter that you get Reminder prompts. 
3. Select Continue. 
4. 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!