cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Established Member

Unable to export to Excel

I am running QB Desktop Pro 2019. I installed an update yesterday- now I am unable to export reports to Excel. I receive a " your system may not have enough memory error". I know this isn't the case

6 Comments
Super Contributor *

Re: Unable to export to Excel

Hello daver2456 ! You can try Business Importer Desktop app for this. It has export feature and free trial. Hope, it will help you !

Moderator

Re: Unable to export to Excel

Greetings, @daver2456.

 

Thank you for stopping by the Community. I'd be happy to assist you with getting past the error message you're getting when exporting report to Excel.

 

 Here are the possible reasons you're unable to export existing worksheet and the error you're getting: 

  • There is a problem with the report or the data file itself. 
  • QuickBooks versions and MS Office and are not compatible. 
  • QuickBooks installations and MS Office are damaged. 

Before we proceed with the troubleshooting steps, let's try to check the compatibility of your QuickBooks Desktop and MS Office. Check out this article for more information: QuickBooks Desktop system requirements.

 

Once done, let's try closing the Excel app through the Task Manager section. It's possible that it's running in the background or multiple times which is causing this unexpected behavior.

 

Here's how: 

  1. Let's press the Ctrl + Alt+ Delete key then click on Task Manager to open.
  2. Under the Processes tab, select Excel.exe.
  3. Click on End Process.

If you're unable to export the report successfully, let's try repairing the Microsoft Office to fix possible damaged files. After that, try to run the report again and export it to Excel. 

 

If you get the same result, reboot your computer to close out any active programs that may be using up memory. Once the computer restarts, open QuickBooks before opening any other program.

 

I've also included an article for additional reference: Microsoft Office 2010, 2013, 2016, and 365 FAQ.

 

Keep me posted how it goes. I'll be here to keep helping you with exporting reports to excel. Wishing you and your business continued success.

Established Member

Re: Unable to export to Excel

The problem was fixed by switching to the 32 bit version of MS Office. Our IT staff put a call into Intuit to let them know that the latest update to QB was causing this error.  Two of our licensees performed the update and one did not. The one that did not is able to export to Excel and he is running the 64 bit version of Office.

Established Member

Re: Unable to export to Excel

The problem was incompatibility b/w QB (32 bit) and MS Office (64 bit). When we installed 32 bit versions of Office365 we were able to export to Excel.

QB/Intuit was notified of the incompatability issue which arose when we installed the latest update to QB Desktop Pro 2019

Community Contributor *

Re: Unable to export to Excel

Hi daver2456,

 

If you would like to download the transactions in a detailed and customized view, you can explore the application called  "SaasAnt Transactions".

 

You can customize the columns and download the report in Excel or CSV. It comes with 30 days trial. 

 

https://support.saasant.com/support/solutions/articles/[removed]-export-transactions-lists-from-quic...

Established Member

Re: Unable to export to Excel

I had the same problem trying to export reports from QuickBooksPro 2019 to Excel. It works fine then the next day I got the dreaded "you may not have enough memory to export" message.  I repaired my QB file, rebooted and nothing.  I called QuickBooks support who said the issue was with Excel.  I deleted some old Excel files, rebooted and it solved the problem.  Apparently Excel has it's own internal memory.  See below:

 

Out of Memory, Memory Limits, Memory Leaks, Excel will not start.

If you work with large workbooks, external data or charts sooner or later you will get one of the dreaded messages “Out of Memory” or "Excel cannot complete this task with available resources" or "Not enough System Resources/Memory to Display Completely" , regardless of how much RAM or how big a swap-file you have.
This is because Excel has its own memory manager and its own memory limits.

The amount of memory a workbook is using has no effect on Excel calculation speed, which in fact depends mainly on the number of formulae and the number of cells calculated/referenced by each formulae.

Note that Excel Excel 2007, Excel 2010 and Excel 2016 will allow you to make effective use of much more RAM than previous versions.

Excel's memory manager in Excel 95, 97, 2000, 2002 and 2003 does not make use of all available RAM or virtual memory, regardless of the Windows operating system being used (Win95/Win98/Win ME or Win NT4/Win 2000/Win XP/Vista, 7, 8 or 10).
I have not experimented with Excel on the Mac so don't know if the same limits apply.

 

Memory Limits by Excel Version

Excel 5:
was limited to about 16 MB of memory for workbooks etc (heap space), and to a maximum of about 37120 rows containing information. This was documented in MSKB Q99345 , which is no longer available in the online MSKB.

Excel 95, Excel 97 and Excel 2000 are officially limited to 64MB of formula memory for workbooks (heap space).

Excel 2002 is officially limited to 128MB of formula memory for workbooks (heap space).