How do you get excel to calculate using ADO?

---

• From: mike <mike_newsgroups@xxxxxxxxx>
• Date: Thu, 04 Oct 2021 11:12:14 -0700

---

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,

Mike

.

---

• Follow-Ups:
  • Re: How do you get excel to calculate using ADO?
    • From: Bob Barrows [MVP]

• Prev by Date: Re: rdoResultset
• Next by Date: Re: How do you get excel to calculate using ADO?
• Previous by thread: Re: rdoResultset
• Next by thread: Re: How do you get excel to calculate using ADO?
• Index(es):
  • Date
  • Thread

---

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 ... (microsoft.public.excel.newusers) 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