I get an error when choosing "Export to Excel" in SharePoint:
Excel cannot complete this task with available resource. Choose less data or close other applications
What can the problem be?
The problem is that your computer is running out of memory and cannot complete the job. Reboot your computer, close any apps and programs that are not required, so you have the most memory available. Then try again. If you run into the same error, you will need to run this job from a computer with more memory.
I suspect that you have excel 86x. Your excel can only call so much memory (2gb if you have a 86x windows or 4gb if its 64x windows version off the top of my head) so while your computer may be fine, it is limited by your excel version.
[Edit] If you are running 64x version of excel on a x64 system and assuming you have enough physical memory then maybe your computer has limited virtual memory - check and see if over 4gb is available for it to use.
I am speaking from experience here as it has happened to me. Teylyn is right in saying its not server side.
Can I suggest making a blank list - adding 1 item and seeing if that can be exported to excel. If that doesn't work then maybe its to do with permissions.
Microsoft offers several explanations as well as troubleshooting steps for this error here: https://support.microsoft.com/en-us/help/2779852/how-to-troubleshoot-available-resources-errors-in-excel
I would start by monitoring my pc's memory usage when trying to export the file to excel. You can open the resource monitor and keep an eye on the memory usage when doing the export. If you are not running low on memory, then I would look at the version of excel that is installed. Try updating to the latest version if not already there. I would also test this from another PC with Excel installed and see if I had the same error. If so, Start looking at the contents of the list in SharePoint. Is there something that is not compatible?