If they update when you close then open the file, couldn't you disable maintain database connections perhaps to achieve the same thing.
Russ > -----Original Message----- > From: Sam Clement [mailto:[EMAIL PROTECTED] > Sent: 01 January 2000 10:53 > To: [EMAIL PROTECTED] > Subject: [ cf-dev ] OT: updating dynamic fields in excel > > > Not sure if anyone's had experience with this on this list > but I thought it would be worth a try. > > I can update an excel sheet through a web form using an ODBC > connection, but none of the dynamic cells in the excel sheet > are updated when a new query is made. Is there any way to > get excel to update itself without opening and closing the excel file? > > Longshot, I know... > > Cheers, > > Sam Clement > ABOVE Studios > Boutique Design Solutions > 7 Sunny Place - Cascade > Trinidad + Tobago - West Indies > T: (868) 621 3626 W: abovestudios.com > > > -- > These lists are syncronised with the CFDeveloper forum at > http://forum.cfdeveloper.co.uk/ > Archive: > http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > CFDeveloper Sponsors and contributors:- > *Hosting and support provided by CFMXhosting.co.uk* :: > *ActivePDF provided by activepdf.com* > *Forums provided by fusetalk.com* :: *ProWorkFlow > provided by proworkflow.com* > *Tutorials provided by helmguru.com* :: *Lists > hosted by gradwell.com* > > To unsubscribe, e-mail: [EMAIL PROTECTED] > -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
