Goal: To convert all formula cells contained in a workbook to their cell values using an Excel macro.

This presentation will show you how to convert all formula cells contained in a workbook to their cell values. For illustrative purposes, we have applied the RANDBETWEEN formula to generate a forecast for Revenue, EBITDA and Operating Cashflow.

Download Spreadsheet Vault SpreadsheetVault – Covert all formulas to values in workbook (solution).xlsb