Excel "Damage to the file" Error When Exporting With SSRS 2005

I am getting an error: "Damage to the file was so extensive that repairs were

not possible. Excel attemted to recover your formulas and values, but

some data may have been lost or corrupted." in some instances when

exporting toexcel.

The report is no different than any othere report. This report uses rectagles and text boxes to control layout with two tables but it's pretty straight forward. This only happens for this particular report when exported only to Excel. I am using SQL2005 SP1.

Any ideas, thoughts, or references are welcome.I can't believe noody answered this yet. I saw the same behavior and the only way we got it to work is to re-publish the data associated with that report AND those parameters we used. Don't ask how it worked but it would work for some parameters on the same report and for others it would fail.|||I actually dissected the report pulling parts out as needed to build up another report that eventually rebuilt the broken one. I hoped that at some point I would come across the problem... Of course I couldn't be so lucky.

So I started from a "test" report built the query, tested, pulled a table on, tested, added fields, tested, add more fields, tested, yadda, yadda, yadda and so on until at some point it was a matter of applying our standards like labels, report reference, etc. I really should investigate the rdl to determine if this was corrupted in some way, or any major differences from the reconstructed report. I did check to ensure it was well formed and all that before the reconstruction and then trashing it...