Are you running the latest service pack for Reporting Services?
Prior to SP1 the file format was MIME Encapsulation of Aggregate HTML (MHTML), which could only be opened in Excel 2002 and later.
--------------------
Colt 45 - the original point and click interface