Can somone please look into this issue.
Sorry for the late reply. Communication breakdown on my end.
I can duplicate the problem when I use the older Excel format. Using the .xlsx format works correctly. I have forwarded this information to our Development and Software Quality Assurance (Testing) departments for review. In the mean time, use the Export Records... or select the .xlsx format.
Here is some information from our Testing department.
The Export Records command gives you the ability to export sub-summarized information. Save Records As Excel gives you the ability to save RECORDS to an Excel file using the current layout. Since there is no Body (no individual record information) in the current layout, no records are exported, leaving an empty file.