Hi,
I have excel file with two (2) sheets (sheet1 and sheet2)
In sheet1 it has a formula like for example sum all of records from column A of sheet2.
Then I am populating data from sql to excel and append to sheet2.
now the problem is,
when I open the excel file,
the formula in sheet1 is not computing (sum)
the new record of column A in sheet2 automatically.
but if I'm going to enter to the cell with formula, press F2 and Enter,
it will recompute.
how can I do it automatically recomputes all the records?
script is simplly
tDBInput rowmain to tFileOutputExcel Appendexisting file and sheet is true.
Thank you
