How do you get excel to calculate using ADO?

hello everyone,

I can put and read values from excel using ado. I think the main
point of using excel is you can use it do some calculations. however,
when i put values in some cells and read the values of cells that
normally calculate something using those inputs, it doesnt work. I
have to open excel manually, then close it, before the values of those
cells update. How do I get excel to calculate from ASP using ADO or
some other method so that I can read the updated values?

Thanks for any help,



Relevant Pages

  • Re: Rounding Problem
    ... I would suggest that you NOT use the "Precision as displayed" setting. ... It can cause rather odd results in calculations if various cells have a different number of decimal places. ... Microsoft MVP - Excel ...
  • Re: Problems using VB.Net OleDbDataAdapter and Excel
    ... Formula cells cannot be updated using ADO. ... Using ADO classic, Jet and OLE DB, I get slightly different behaviour ... Note that although you can change non-formula cells via ADO, any Excel