Jan 20 2020 04:29 PM
I have been using Excel in Office 2016 (and earlier versions of Excel) for many years on Windows 7. I recently upgraded to Win 10. I have an Excel file that is password protected. For years I have saved it as a password protected pdf so that I can carry it around on my iPhone. Now, when I save it as a pdf, the password protection is lost. I have tried using the File/Export/Create PDF function, but the Options menu does not offer me the password feature. Any suggestions?
Jan 20 2020 04:51 PM - edited Jan 20 2020 04:57 PM
Jan 20 2020 05:56 PM
Hi Abiola,
Thanks for the reply. My problem is not with the password-protected Excel file. My problem is with the pdf file. When it saves as a pdf, the password protection is eliminated. If I want to pay Adobe an exorbitant fee, I can rent the function on Adobe, but I would rather have it come through as part of Excel.
As I said, I have used the “Save As PDF” function on Excel for years, and it has always kept the password used on the Excel file. Now, after installing Windows 10 on my computer, it doesn’t.
Frank
Feb 14 2022 11:51 AM
@fjbruni - just ran into the same issue. In Word I can save to PDF and password protect it, but in Excel I can't. Did you ever figure out how to do it?
May 27 2022 09:44 AM
@BobBloemen After saving it as a PDF, upload and download it from this website to password protect it: https://smallpdf.com/protect-pdf
May 27 2022 01:26 PM
After they convert the file to PDF.
Open the PDF file Select "Protection"* → "Encrypt" → "Encrypt with password"
via the tool selection (*depending on the version also tab "Display" → "Tools" → "Protection")
Enter a first password for opening the document in the dialog window that opens
(Tip: for compatibility, click on the oldest possible if the recipient does not have a current Acrobat version).
Repeat password entry Click OK, done
Jun 20 2022 09:09 AM
I tried this and emailed the file. Still had no pwd protection.
Dec 26 2022 11:06 PM
@fjbruni From 2yrs ago you may have long since found a work-around. If anyone is searching as I was, you may use Adobe's online (free) tool, sign-in not required --- https://www.adobe.com/ca/acrobat/online/password-protect-pdf.html
Feb 06 2023 10:49 AM
@sereenlee I tried this link, and the first time it worked. But when I tried a second file, it wouldn't proceed unless I signed up for an account or for a free trial.
Mar 07 2023 02:25 PM
@fjbruni I am having the same issue. Can't save a protected excel file to pdf and have it retain the password. Can't save an unprotected excel file to pdf and add a password during the process. Easily able to do this in Word. Would really like to do this just as easily in Excel. Without resorting to a paid Adobe license. Any new suggestions?