The RemoveFormulas method removes Excel formulas from the entire workbook, while leaving their values. This method does NOT remove Conditional Formatting or Data Validation.
public void RemoveFormulas()
Public Sub RemoveFormulas()
//Create an ExcelApplication object
ExcelApplication xla = new ExcelApplication();
//Open a workbook containing formulas
Workbook wb = xla.Open("FormulasWorkbook.xlsx);
//Call RemoveFormulas
wb.RemoveFormulas();
'Create an ExcelApplication object
Dim xla As New ExcelApplication
'Open a workbook containing formulas
Dim wb As Workbook = xla.Open("formulasWorkbook.xlsx")
'Call Removeformulas
wb.RemoveFormulas()