cancel
Showing results for 
Search instead for 
Did you mean: 
FaizanSehgal
Level 1

Import or export MS Excel files

Hi Experts,

 

I am using Quickbooks Premier 2018 UK edition. I can successfully export to excel file. however when i try to update existing file its giving me an error. 

Here is the screenshot of the error. Kindly help

Thanks

QB.JPG

4 Comments 4
JamesDuanT
Moderator

Import or export MS Excel files

Hello Faizan,

 

There are many reports that you can export to Excel and update them through QuickBooks Plugin. However, some of the reports don't support the QuickBooks Plugin function in Excel. As a result, you'll receive this error.

 

You'll need to export the report to Excel as a new file every time you want to update it.

 

You can check out this article to see the reports that don't support the QuickBooks Plugin: The Balance Sheet is not Updating When Exported to Excel.

 

Let me know if you have other concerns.

FaizanSehgal
Level 1

Import or export MS Excel files

Hello James,

 

Thanks for your reply,

Firstly, i do not have any plugin. Simply i export to excel (like Trial Balance, Profit n Loss) Invoices etc.

I am not exporting anything that is in the link you sent me. 

So what to do in such case?

 

Thanks

JamesDuanT
Moderator

Import or export MS Excel files

Thanks for the additional details, Faizan.

 

It's possible that the error was triggered by the following factors:

  • Damaged MS Excel software
  • Damaged QuickBooks software
  • QuickBooks and Excel versions are compatible with each other

Here are the things that we can do:

  1. Update QuickBooks to the latest release version.
  2. Review the software compatibility of the two software. You can use this link for more information: System Requirements for QuickBooks 2018 and Enterprise Solutions 18.0.
  3. Repair or update the MS Excel software if necessary.

If you need further troubleshooting steps, I'd recommend reaching out to our QuickBooks Technical Support Team:

  1. Go to this link: https://help.quickbooks.intuit.com/en_US/contact#.
  2. Select QuickBooks Pro/Premier United States in the upper-right corner of the page.
  3. In the first section, click Solving Issues & Error Messages.
  4. Choose Common Errors.
  5. In the second section, choose how you want to reach them (phone, chat, or email).

Fill me in if you need anything.

Kirill - CloudBusiness LLC
Level 3

Import or export MS Excel files

Hello Faizan,

There is an app in the Desktop AppStore named Business Importer Desktop. It has updating feature for a huge variety of entities and free trial for 14 days. I hope, that will help you!

 

Need to get in touch?

Contact us