I have a large workbook with a number of sheets that extract data from other
programs.
I need to distribute it by email to people who don't have access to those
programs, for whom the links won't work.
Is there a way of converting formulae to values for a whole book or sheet in
the same way as for a selected range ?
Thanks
Colin2