Copy / Paste Special / Values for a whole spreadsheet ?
Hi
I haven't tried it but I suppose you could group the sheets (right-click on
a sheet tab and select 'Group all') and then click on the select all button
(above row 1 and to the left of column A) and then Copy/Paste
Special/Values.
Make a copy before you try, though!
Andy.
"Colin2" wrote in message
...
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
|