I am trying to export out a simple table to an Excel spreadsheet

PHP Version 5.3.3
MySQL 5.1.61
Dreamweaver CS 5.5
Microsoft Office 2007
Universal Data exporter verion 1.1.4

I have a table with one record in it. I am using a recordset like this:
SELECT *
FROM leases

When I run the page, Excel does open, but there is no data exported. The Excel sheet is blank.

The error log has this error:
8 is not a valid MySQL result resource in /var/www/vhosts/website/httpdocs/ScriptLibrary/dmxDataExporter.php on line 790

or

9 is not a valid MySQL result resource in /var/www/vhosts/website/httpdocs/ScriptLibrary/dmxDataExporter.php on line 920

If I display the table on the page and create a link and apply the ude behavior, then the export to Excel works ok. But, if I try to export from a recordset using the ude servior behavior, I get the above error.

Do you know what the problem might be?
Thanks.

I am exporting from a datagrid. It works on local computer and I have it working on another live website and far as I know I've done everything the same.

I have it working but it is strange it will export records held in the datagrid up to 35 doesn't work for 40 , works for 45 and doesn't work for 50. I seem to remember the same sort of problem on my other project when I used this.