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.
Bookmarks