Getting an error when export a sharepoint list as query in excel

Question

When I tried to export for excel my sharepoint list, and I open the query on excel it shows the follow message as an error::
"There isn't enough memory to complete this action. Try using less data or closing other applications"

I tried to look for help in youtube and everwhere but without success.

Does anybody here knows how to fix this?

Answer 1

Hi @Ma06,

It sounds like you're encountering a memory issue on your device. To resolve this, you can try a few things:

1. Close Unused Applications: Close any applications or browser tabs that you're not currently using to free up memory.
2. Test with 64-bit version of Excel: In any 32-bit application, there's a 2-GB limitation. If your processes need to use more than 2 GB's, then you need to carefully consider moving to Microsoft Excel 64-bit version. The 64-bit version allows all available physical RAM on the machine to be used.
3. Clear Cache: If applicable, clearing the cache of specific applications or your browser can also free up memory.

Here is the document for reference

https://learn.microsoft.com/en-us/office/troubleshoot/excel/available-resources-errors

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hello RaytheonXie_MSFT.

Unfortunately, is not a memory issue since it is happening in more than one company device.