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

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

20 Comments
Highlighted
Level 2

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 !

Highlighted
Moderator

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.

Highlighted
Level 1

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.

Highlighted
Level 1

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

Highlighted
Anonymous
Not applicable

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...

Highlighted
Level 1

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).

Highlighted
Level 1

Unable to export to Excel

Hi Susan, would it be possible to share which types of files you deleted, or where they were located? How do files, just residing on the hard drive, affect the memory of Excel? Thanks in advance for your reply.

Highlighted
Level 1

Unable to export to Excel

Unable to sort this issue. As per your suggestion i have installed the 32bit version of MS office still not working.

 

I am using QB Prem 2019 version R12 product update.

Kindly let me know the solutions.

Highlighted
QuickBooks Team

Unable to export to Excel

HI there, @bj13.

 

I'd like to ensure that you'll be able to export reports to Excel successfully.

 

I appreciate you for installing the 32bit version of MS office. However, since the problem continues, I recommend following the suggestion presented by SusanRUser above. This way, you'll be able to eliminate some old Excel files, which can free up its memory and help you export the reports without any issues.

 

You can also try to uninstall and reinstall Excel to refresh its data and help fix unexpected errors while exporting reports. You can check out this link for complete details on what are the processes that you can take if you've encountered exporting issues in QBDT: Fix export to Excel issues in QuickBooks Desktop.

 

If deleting old files doesn't make a difference, I suggest contacting your IT professional. They'll be able to further isolate the root cause of this matter and provide you with a permanent fix.

 

Be sure to update me here on the results of your testing, I want to ensure this matter gets resolved. 

Highlighted
Level 2

Unable to export to Excel

I'm piggy backing off your response because I don't see where I can post a new question.

I just had to reinstall office and now quickbooks won't export to excel.  I've tried every solution on all these pages but it still doesn't work - all buttons are greyed out.

This is extremely annoying - are there any other solutions?

Highlighted
QuickBooks Team

Unable to export to Excel

Thanks for joining this thread, @susand2020.

 

I appreciate you performing the steps provided by my colleagues, have you tried to repair your Excel app? You can give it a try. Once done, export the report again from QuickBooks Desktop. If the same thing happens, I suggest reaching out to our technical support team. They use specific tools to do a screen-sharing to investigate the root cause of the issue and generate steps to fix it for you.

 

Here's how:

 

  1. Go to the Help tab.
  2. Choose QuickBooks Desktop Help.
  3. From the Have a question? page, enter Unable to export reports to excel.
  4. Click Contact us.
  5. Choose Start a message

To ensure that you will be assisted immediately, our support is available from 6:00 AM to 6:00 PM on weekdays and 6:00 AM til 3:00 PM on Saturdays. For more info please check our support hours.

 

Also, you may consider reading helpful articles that can guide you in managing your books in QuickBooks Desktop: QBDT help articles. This includes topics such as setting up and connects apps, track employees' time, set up online payments, etc. 

 

Let me know if there's anything else you need about managing your reports in QuickBooks Desktop. I'm always right here to help. Take care always. 

Highlighted
Level 2

Unable to export to Excel

Thank you - but I don't even see the 'contact us' option.

 

I've read every article and used the QB repair tool,  I am not finding solutions!

Like I said, I don't even see the contact us option in the desktop help tab - I've lost so many hours I am very frustrated - and..... they don't make it easy to contact tech support

 

Highlighted
QuickBooks Team

Unable to export to Excel

Hello, @susand2020.           

 

This is not the type of service we want you to experience. We've made some changes to our support options for QuickBooks Desktop. Our representatives are available through chat or messaging to accommodate all our customer's concerns effectively.

 

You can follow the steps given by my colleague @DivinaMercy_N to get in touch with our support. Below are screenshots for visual reference:

 

 

 

I'm always around to lend a hand if you have more QuickBooks concerns. Take care and stay safe always.

Highlighted
Level 2

Unable to export to Excel

I had tried everything I could find about fixing this issue of grayed out Excel.  Had a QB's tech provide me this solution and it worked.

 

Please be cautious about working in Registry.  Go into Regedit and find this key - delete it.

Computer\HKEY_CLASSES_ROOT\TypeLib\{00020813-0000-0000-C000-000000000046}\1.9

 

The issue came back recently so I went back into editor and found this key had been created again.  Deleted it and greyed out excel issue went away again.  So this key is the key.

Highlighted
Level 1

Unable to export to Excel

I am having the same problem ("Your system might not have enough memory to use Excel") and none of the fixes I have encountered have worked. I am running QuickBooks 2019 Premier Nonprofit on Windows 10, Microsoft Office 2019, and a computer with 8GB memory and 500GB free space. Further, Excel has worked via QuickBooks and still works now whenever not in QuickBooks, so I know it's not a problem outside QuickBooks exporting. 

 

I have:

1. Run Repair on Microsoft Office

2. Updated Microsoft Office

3. Uninstalled and reinstalled Microsoft Office

4. Rebooted computer after each of the above steps

5. Disabled protections in Excel

 

And so far nothing has been effective. What needs to happen for QuickBooks to stop giving me this incorrect error? What is causing it? 

Highlighted
QuickBooks Team

Unable to export to Excel

Thank you for all the details, @flscenter.

 

Since the issue persists, I recommend reaching out to our Customer Care Support Team. They have tools to investigate and figure out the root cause of this issue.


Here's how:

  1. Select QuickBooks Desktop Help from the Help menu.
  2. Click Contact Us.
    QBDT HELP.JPG
  3. Type in a short description of your concern, then Continue.
  4. Choose a way to connect with support.

 

To make sure that your concern will be address immediately, I recommend checking out our support hours to know their availability.

 

I'd appreciate if you can update me on how it goes or if you have any questions. I want to make sure this gets resolved. 

Highlighted
Level 2

Unable to export to Excel

This is still unresolved. I cannot understand why it's still an issue, this was working fine until about a month ago.

Highlighted
QuickBooks Team

Unable to export to Excel

I appreciate the update that you gave, @susand2020.

 

I'd like to ensure that this issue gets sorted out so you can get back on track.

 

To help determine the reason behind this matter, I suggest contacting your IT professional. This way, they'll be able to check your devices' memory and get to the bottom of this problem.

 

However, if doing this doesn't make a difference, I recommend contacting our Customer Care Team. They'll be able to run a remote viewing session that can further investigate why you're unable to export reports in Excel, given that you've already performed the steps shared above.

 

To contact them, you may follow the instructions provided by DivinaMercy_N and Pabz_L in this thread.

 

Please update me on how the conversation goes. I'll be around to assist you if there's anything else that you need. Take care!

Highlighted
Level 1

Unable to export to Excel

I had tried EVERYTHING and this is the only thing that worked! stupid registry key! I had this issue on every new PC I tried, reinstalled office, QB, upgraded QB to v21, different office versions, called support, nada. thanks for sharing this!!

Highlighted
Level 1

Unable to export to Excel

delete this key and it will work: Computer\HKEY_CLASSES_ROOT\TypeLib\{00020813-0000-0000-C000-000000000046}\1.9

Need to get in touch?

Contact us