question/trouble saving worksheet

[jeffm55]

I have a workbook that contains two worksheets, one that
displays data from a vlookup, two that contains the data
source. After i perform my vlookup items, i would like
to save the first sheet was a worksheet by itself so that
i can email it to someone. Currently if i try to email
it is trying to email the entire workbook. The second
worksheet is about 2 megabites and i would not like send
this information to the reciepent. Has anyone found a
fix for this. I can currently make my worksheet an adobe
PDF document and capture the data but I have other co-
workers that do not have access to adobe. HELP!!

 

[Frank Kabel]

Hi
copy the data range on your first sheet and insert it again with
'Edit - Paste Special - Values' to remove the formulas.

also have a look at
http://www.rondebruin.nl/sendmail.htm
for emailing selections/sheets of your workbook

 

[Guest]

Caution....if you need to retain the formula ahwwr for
later input....first save the sheet to a new workbook,
then, as Frank says....break the links and destroy the
formulas with a paste special...values