I&#039;m using ASP to read from an Excel datasource. This is working fine to get static data, but the Excel worksheet is dynamic, and I need to make it recalculate some random values every time it&#039;s accessed. Anyone know of a way to make an Excel worksheet recalculate from ASP?<BR><BR>Currently, I&#039;m accessing it as follows (which gets me the same data every time, without recalculating the random values):<BR><BR>----<BR><BR>Set conn = Server.CreateObject("ADODB.Connection")<BR><BR>con n.Open "DBQ=" & Server.MapPath("excel-data.xls") & ";" & _<BR> "DRIVER={Microsoft Excel Driver (*.xls)};"<BR> <BR>Set rs = Server.CreateObject("ADODB.Recordset")<BR><BR>rs.O pen "SELECT * FROM cues;", conn, _<BR> adOpenStatic, adLockPessimistic<BR>...<BR><BR>---<BR><BR>I also tried something along these lines:<BR><BR>Set objExcel = server.createobject("Excel.Application") <BR>Set ws = objExcel.Workbooks.Open("excel-data.xls").Sheets("Sheet1") <BR>objExcel.calculate<BR>...<BR><BR>But this always gives me the error "Server object, ASP 0177 (0x800401F3)<BR>Invalid ProgID".<BR><BR>Any help would be much appreciated!