I don't believe the max columns of excel were exceeded as I have a small amount of data + it should say it in the log file like it did for the others.
When exporting the file I select my desktop (which is a path destination I believe) so I don't really get it. I have also liberated space on my computer to make sure it wasn't the cause. So yeah, I have no idea what's going on!