Start with New Excel file Rename sheet1 to “interview” Save as “xlsx” named “testMaster” Save as “xls” name “oldExcel” Run CF below, then open each.  “xls” will autocalc cells properly.  “xlxs” WILL NOT- Cells display as “0” although formula is correctly embedded and does calc with keystroke “cntrl-alt-f9” <cfset DummyID = randrange(12345,99999)> <cfset excelFileToUse = “dldExcel.xls”> <cfset excelFileToUse = “d:testMaster.xlsx”> <cfset fileExt = listLast(excelFileToUse,”.”)> <cfset CompanyLink = “HYPERLINK(“”http://localhost/customers/customer.cfm?customerID=156″”,””My Company””)”> <cfset contactLink = “HYPERLINK(“”http://localhost//customers/customer.cfm?customerID=156″”,””Johnny Walker””)”> <cfset quoteLink = “HYPERLINK(“”http://localhost/quotes/oldquote.cfm?quoteID=15263″”,””15626″”)”> <!— Read […]