I'm assuming you're viewing the spreadsheet via IE? If so my initial thoughts would be to hardcode a javascript refresh after running the query. Would that not do the trick? hth Mark
-----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]
