Password error when e-mailing a spreadsheet.
 

I receive this error when attempting to e-mail a spreadsheet (by clicking
'Send this sheet' in Excel):

"A sheet in the workbook you are trying to save is password protected.
Password protected sheets cannot be saved in the HTML format. To save this
file in HTML, you must first remove the password."

Is there a workaround or solution for this error that will allow me to
e-mail a password protected spreadsheet from within Excel?

Thank you.

Send it as an attachment, but send it as a *.xls file--a real workbook????

swellett wrote:

I receive this error when attempting to e-mail a spreadsheet (by clicking
'Send this sheet' in Excel):

"A sheet in the workbook you are trying to save is password protected.
Password protected sheets cannot be saved in the HTML format. To save this
file in HTML, you must first remove the password."

Is there a workaround or solution for this error that will allow me to
e-mail a password protected spreadsheet from within Excel?

Thank you.

--

Dave Peterson

"Dave Peterson" wrote:

Send it as an attachment, but send it as a *.xls file--a real workbook????


One of the several agencies to which the the spreadsheet is e-mailed, does
not use Excel, and cannot open '.xls' attachments.

There is no HTML code present in the spreadsheet, so does Excel use/insert
HTML upon sending?

BTW, I'm using Excel 2000 Premium.

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.

In fact, Microsoft offers a free xl2003 viewer at:
http://office.microsoft.com/en-gb/of...347961033.aspx

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

http://www.openoffice.org, a 60-65 meg download or a CD

===
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.

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

swellett wrote:

"Dave Peterson" wrote:

Send it as an attachment, but send it as a *.xls file--a real workbook????

One of the several agencies to which the the spreadsheet is e-mailed, does
not use Excel, and cannot open '.xls' attachments.

There is no HTML code present in the spreadsheet, so does Excel use/insert
HTML upon sending?

BTW, I'm using Excel 2000 Premium.

--

Dave Peterson

"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