I have a template which draws values from formulas that reference other
workbooks. Is there a way, on save, to convert all formulas to values so the
new workbook is a 'snapshot' that can be distributed without needing the
reference to the linked files?

TIA, Steve