Hi All,

Does anyone know of a way to replace a cell's formula with its result for an entire workbook?

I have a workbook that uses INDIRECT to read data from 25+ other .CSV files. It then compiles this data and builds a heap of charts.

I have found sending 25+ files to someone for them view is causing a few problems, not least because INDIRECT can be a bit troublesome on some computers.

So. similar to break links, I would like to save all the values in a copy of the workbook and email to people for review.