private void dataGridView1_CellValueChanged(object sender, DataGridViewCellEventArgs e) { //TODO need to do some sanity checks here... do these in property setters UnitConversion.unitDatabase.Update(dataGridView1.Rows[e.RowIndex].DataBoundItem); UnitConversion.InvalidateCaches(); //force the spreadsheet to recalc since a change happened Microsoft.Office.Interop.Excel.Application app = (Microsoft.Office.Interop.Excel.Application)ExcelDnaUtil.Application; app.CalculateFullRebuild(); }