after update cell value in excel, the formula which depend on the updated cell, should get executed and then values of cells (which is in different sheets) needs to update automatically using c# and wep api. Once formula get executed, I want to access values from sheets which is updated using formulas.
I tried OpenXML, ClosedXML and even Microsoft.Office.Interop.Excel, but no luck.
Your help is highly appreciated.
Note: I am using xslm format file.