CF to Excel oddity

[gilYoung]

I have a page that outputs a report in Excel format using CFCONTENT and CFHEADER. It works great, unless the report contains more than 68 records.

If more than 68 records are in the file, Excel still opens it, but it displays the raw HTML instead of rendering the tables. The odd thing is that I reduced the file size by about 15%, thinking file size was the factor, but it still broke on the 69th record.

Has anyone ever encountered this? If so, have you found a solution to it? Answers, tips, and jokes about the number 69 are welcome.

 

[wirelessworker]

Can you provide an example of your code? This might help in nailing the problem.

 

[gilYoung]

That's gonna be tough, Wireless. The application outputs data about our company's profitability, and it's inside an intranet. I'll see if I can't dummy up some data and move the page outside the intranet and let you know.

In the meantime, has anyone run into the same type of problem?

Thanks for replying,

Gil