Thanks Ken, But this doesn't seem to have any effect.
Regards, Trent From: [email protected] [mailto:[email protected]] On Behalf Of ken zheng Sent: Tuesday, 26 May 2009 8:17 PM To: [email protected] Subject: RE: Excel Services In the External Data section, in the Connection Lifetime box, type a value in seconds for the maximum time for a connection to remain open. Connections that expire are re-opened when the next query is received (type -1 to never close and re-open connections). have a try Ken ________________________________ Date: Tue, 26 May 2009 04:03:05 -0400 From: [email protected] Subject: Excel Services To: [email protected] Hi Guys, Just wondering if there are any Excel Service gurus out there that might be able to help me and my client. We are having trouble getting excel services to refresh the data onload when connecting to a sharepoint list. Does anybody know if this is even possible. I have selected the option to refresh data onload when the connection datasource but it doesn't actually refresh. Even forcing a refresh through the webpart doesn't accutally refresh. My client has some fantastic pivot tables working but its displaying out of date data. Has anybody got this to work before? Any assistance would be greatly appreciated. Even if I can get a confirmation that it cant be done. Regards, Trent ________________________________ Support procedure: https://www.codify.com/lists/support List address: [email protected] Subscribe: [email protected] Unsubscribe: [email protected] List FAQ: http://www.codify.com/lists/ozmoss Other lists you might want to join: http://www.codify.com/lists ________________________________ Support procedure: https://www.codify.com/lists/support List address: [email protected] Subscribe: [email protected] Unsubscribe: [email protected] List FAQ: http://www.codify.com/lists/ozmoss Other lists you might want to join: http://www.codify.com/lists No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.339 / Virus Database: 270.12.30/2115 - Release Date: 05/25/09 18:14:00 -------------------------------------------------------------------------------- Support procedure: http://www.codify.com/lists/support List address: [email protected] Subscribe: [email protected] Unsubscribe: [email protected] List FAQ: http://www.codify.com/lists/ozmoss Other lists you might want to join: http://www.codify.com/lists
