I assume you use lots for formula for links and for extracting data from
other programs.

Try :
Go to menu edit/link/break links....
Which will convert all external links (formula) to their current values for
the whole file.

--
Best regards,
---
Yongjun CHEN
=================================
XLDataSoft - Data Analysis Expert, Excel/VBA Specialist
- - - - www.XLDataSoft.com - - - -
Free Excel-Based Data Processing Tool is Available for Download
Free Excel / VBA Training Materials is Available for Download
=================================

"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