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

Ma06 0 Reputation points
2024-07-04T16:23:33.9566667+00:00

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?

Microsoft 365
Microsoft 365
Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line.
4,890 questions
SharePoint Server
SharePoint Server
A family of Microsoft on-premises document management and storage systems.
2,340 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,887 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,685 questions
0 comments

5 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. RaytheonXie_MSFT 35,466 Reputation points Microsoft Vendor
    2024-07-05T01:56:54.39+00:00

    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://video2.skills-academy.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.

    0 comments
  2. Ma06 0 Reputation points
    2024-07-05T11:56:22.0933333+00:00

    Hello RaytheonXie_MSFT.

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

  3. QuickBrownFox 1 Reputation point
    2024-07-30T09:38:02.2333333+00:00

    We've had a similar problem: the same error appeared when opening the query file in Excel, but after clicking "OK" on the error message, the exported data was opened in Excel - missing one specific column.

    When hiding the column from the SharePoint list view and exporting again, there was no error message.

    We found that changing the column to optional and back again to mandatory fixed the bug. After this change on the column, the error message in Excel did not appear and also the column was correctly included in the export.

    0 comments
  4. Rodolpho Sousa 0 Reputation points
    2024-08-15T14:44:41.64+00:00

    @Ma06 i've just got same error here and after follow the suggestions made by @QuickBrownFox i could identify a problematic field (in my case a numeric field that apparently had some wrong numbers typed by users). After hide the field the error disappeared.

    0 comments
  5. Sebastian Sikora 0 Reputation points
    2024-09-27T13:21:24.08+00:00

    I set currency columns to 2 digits decimal and not automatic, that helped me to fix it.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.