Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
"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. |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
"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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? | Excel Discussion (Misc queries) | |||
Applying Existing Password to New Spreadsheet | Excel Discussion (Misc queries) | |||
password protect a spreadsheet to prevent it from being opened. | Excel Worksheet Functions | |||
How do I password protect cells in a spreadsheet created in Excel | Excel Worksheet Functions | |||
How do I password protect cells in a spreadsheet created in Excel | Excel Worksheet Functions |