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
'Create an ExcelApplication object
Dim xla As New ExcelApplication
'Open a workbook containing formulas
Dim wb As Workbook = xla.Open("formulasWorkbook.xlsx")
'Call Removeformulas