Thank you for your input.
I know my issue was really really silly as it is for most of my requests I post here
And the answer was super easy too.
I had gathered over 3000 form entries for that particular site, the server could simply not cope processing the volume into a file.
PHP memory was set to low.
I doubled the memory_limit in my INI editor and the CSV download now works.
Thanks a bunch,