We ran into this issue. Our company standard is still Office97. It sucks. IIRC Office 2000 has an upper limit too...but then when you dump in excess of 2 to 5 MBs to a web browser, you can expect shite to happen. What we did to help alleviate this is to create a temp CSV file on the server with the data then dump it to the browser with the proper http header changes. Excel97 can handle more data this way compared to dumping tables to Excel.
Doug >-----Original Message----- >From: KeAnne Hoeg [mailto:[EMAIL PROTECTED] >Sent: Wednesday, February 26, 2003 10:45 AM >To: CF-Talk >Subject: cfcontent and excel problem > > >I have created an application that uses cfcontent to generate an Excel >spreadsheet of the user's query results. Believe it or not, >we have a few >users who are still using Office 97, and they have encountered >problems >opening these files when the file size is about 2MB and >larger. We don't >experience this problem in Office 2000. We are in the process >of upgrading >the remaining users to Office 2000 or XP, but in the interim, >can anyone >shed any light on why this problem happens with Office 97 and >whether we >should be concerned about eventually encountering this problem >in Office >2000 and XP? The only thing I can think of to do is to make a >text file >available for these users to download if they have problems >with Excel--they >don't seem to have a problem opening the text files. > >Thanks, > >KeAnne > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
