Create the spreadsheet using formulas. Before sending the workbook to your boss, copy the range with all formulas, and from right-click menu use PasteSpecial.Values on same range. (In case you want to keep the formulas for later use by yourself, save the workbook as 1st step, then overwrite formulas with values using PasteSpacial, and then save the workbook with different name - and send the last one to your boss.)