| | | Bruce Sinclair |  |
|  Posted: Wed Aug 13, 2008 11:16 pm Post subject: Re: emailing just one worksheet/tab of workbook |  |
In article <053e56bd-0f01-4ebf-8a98-deb93c3cbdbe@z66g2000hsc.googlegroups.com>, Michelle <teacher24_70@yahoo.com> wrote:
| Quote: | Is it possible to send only one worksheet/tab in an e-mail or is the
entire workbook the only option? Our school district is using Excel
2007 and our secretary would like to be able to send only certain
worksheets to teachers.
|
One way is to :
1) save the file *as* under a new name (this is important  ).
2) delete all the sheets you don't want to send from the new file (...
because of this )
3) save again
4) email that file
Obviously, this doesn't work for linked data to the sheets deleted.
In that case, use a new sheet :
1) save the new sheet as a new file
2) copy the sheet you want to send
3) paste as values into the new sheet
4) save
Send that file.
HTH |
|
