Well, changing the values in the .MHT won't change the gif version of the chart that's embedded, BUT the chart does get updated against the proper values when re-imported to Excel (just tested it).
> -----Original Message----- > From: Ben Nadel [mailto:[EMAIL PROTECTED] > Sent: Tuesday, November 28, 2006 4:09 PM > To: CF-Talk > Subject: RE: ColdFusion and Microsoft Excel > > Doug. That is a good solution idea to explore. As far as charts, I think > the MHT file actually stores a Base64 GIF image of the chart. Then when > you open it up in Excel, it has the GIF chart, but does not recompute > based on the excel data. But, I have not tried anything that complex in > a while. > > If nothing else, this method helps you figure out how to get numeric > columns to render AS text (so that leading zeros don't get taken off and > date/time values don't go all weird). > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261924 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4