"Dave Peterson" wrote:

First, that other agency may have another spreadsheet program that can open
excel files.

Or you may want to verify what type of files they can open and send in that
format.

Or they may want to use a free spreadsheet program. One of these can be found
at OpenOffice.org.

The other agency is the U.S. Army Corps of Engineers and they are quite set
in their ways. And I guess, my agency is as well, because we won't send it
in a format they support.

If you send the workbook via:
File|Send To|Mail Recipient
You're sending the worksheet embedded in the email. And it sure looks like
excel embeds the worksheet using HTML--it's not really a worksheet in a workbook
anymore.

That's exactly how we send it, and I believe you're correct, since it is not
attached, it is sent as an HTML message.

You could either remove the password protection or maybe send the whole workbook
(using one of the options above).

The workbook contains 12 sheets and runs about 600KB, and since we only
e-mail one sheet, we are a little reluctant to send the whole thing. I've
suggested setting up a seperate "e-mail" workbook that updates from our
original workbook, but evidently the author ran into some issues he could not
overcome, so we currently just leave the workbook protected, but without a
password. It's the best solution we have at the moment.

Thank you, Dave.

John Ellett