Missing Columns when exporting to Excel from SharePoint List + Not Enough Memory Error In Excel

Question

When exporting to Excel from a SharePoint list, the file that is exported is an .iqy file. When I open the file in Excel, I receive an error that reads: "there isn't enough memory to complete this action. Try using less data or closing other applications." When I click OK, the same message pops up. I click OK approximately 5-10 times before the message stops appearing and the sheet opens up. The sheet that opens up is missing a handful of columns.

I have confirmed that I have plenty of memory remaining as I watch the task manager pane as i opened the file.

Exporting to Excel:

Memory error message:

So, I'm trying to determine two things:

1. What is causing the Excel memory message?
2. Why are some of the columns missing from the file?

The columns that are missing when the file is opened are:

• "W"
• "D"
• "Quantity"
• "Quantity2"
• "Quantity3"
• "Quantity4"

All other columns look to be accounted for.

Below are my list settings. I can also provide any other information that is needed.

Answer 1

Dear JR_8989,

Good day! Thank you for posting to the Microsoft Community. We are happy to help you.

We understand that you are experiencing issues when exporting a SharePoint list to Excel, such as error prompts and missing columns in the Excel file. We're sorry to hear about the inconvenience this has caused.

Based on the screenshots you shared, it appears the issue occurs with number columns, both required and not required. We conducted a quick test and were unable to reproduce a similar situation on our end.

We have also researched the error message you provided. Please try using the "Export to CSV" option to see if it makes any difference. Additionally, refer to the suggestions shared in a similar thread for potential solutions: Why some of the columns are missing, when exporting to excel from - Microsoft Community

If the issue persists, it might be related to a background service that requires backend investigation. In this case, we recommend opening a support ticket with technical Support team. They can investigate the backend connection and provide a more permanent solution.

If you are the Microsoft 365 admin of your organization, you can follow steps in this article to contact Online Support. The support team has higher permissions than us and can remotely check the situation on your side, collect logs, and help you troubleshoot.

If you are not an admin, please refer to How do I find my Microsoft 365 admin? - Microsoft Support.

If the understanding above does not align with your issue, please feel free to post back and clarify.

We apologize for the inconvenience once again. Your patience and understanding are greatly appreciated. Stay safe and healthy.

Sincerely,

Rhoda | Microsoft Community Moderator

Answer 2

Rhoda,

Thank you for the quick reply.

I did happen to stumble upon this link while looking for solutions:

Why some of the columns are missing, when exporting to excel from - Microsoft Community

I tried all recommended steps and was able to get one missing column to appear in the Excel export but nothing else.

I will try these steps one more time today before I say they do not work.

I did use the Export to CSV which seems to export everything but it does not export the data into a filtered and formatted sheet like the Export to Excel does. We are trying to figure out the issues with the Export to Excel function because we would prefer that the sheets were filtered and formatted.

If we can't find a fix to this issue, i'll probably look into a Power Automate or PowerAPP that would save the data and export it into the desired format.

I will reply once I have re-tried the suggestions from the link above.

Thanks!
John Rogalski

Answer 3

Dear John Rogalski,

Thanks for posting back.

If the issue persists after re-trying the suggestions, I believe there should be an issue with the backend service and I am sorry to convey that the issue need to be further investigated by the related development team, where they can collect the related HAR logs while reproducing the problem and perform further investigation.

So, I request you to connect with the IT admin of your organization (How do I find my Microsoft 365 admin? - Microsoft Support) and raise a new service request from the Microsoft 365 admin center so that the related development team will connect with you and investigate the issue further.

Reference: Get support - Microsoft 365 admin | Microsoft Learn

Meanwhile, if you are trying to use Power Automate or Power APP solution as a workaround, we would like to request you to post your detailed concern in the related community i.e., Microsoft Power Platform Community Forum Thread to get the detailed help from the experts. Apologies for redirecting you to different community as the members in the category posted focus on the users with the Microsoft 365 concern and have limited knowledge on the Power Automate or Power Apps, so to get the fast and better assistance, we have redirected you in the correct path.

Similar thread for your reference: Solved: Sharepoint list auto export to excel

Solved: Exporting SharePoint List Items to Excel From PowerApps

Best Regards,

Rhoda

Answer 4

Wow! Changing from non-mandatory to mandatory resolved the issue. Thanks QuickBrownFox22!!