bianel raiman ballads

[Maribeth Seagers]

I have an Excel file that is password protected. When I log in to the account from the computer and try to open the file, I click on it but there is no option or access to type the password to open the file. This only happens on the account from the computer and not on the account from the mobile phone (where I have the option to type in the file password). I click on the blue "Open" button and then click on the link to Excel - and it shows me an error message and does not give access to typing the password of the file. As a result, I currently do not have any access to the file from my computer. How can I solve this ??

Did this post help you? If so, please give it a Like below.
Still stuck? Ask me a question!
Tips & Tricks Find new ways to stay in flow or share your tips on how you work smarter with Dropbox.

Attached is a link to the page I see, immediately after I click the "Open" button of the encrypted Excel file. As mentioned, I have no option to type in my password and open the file I encrypted. I would be very grateful if you could help me!

Did this post not resolve your issue? If so please give us some more information so we can try and help - please remember we cannot see over your shoulder so be as descriptive as possible!

Can you be more specific?
What does it mean to open Excel from your computer?
When I click on the Excel file on the Dropbox site - I get the error message.
Can you explain exactly what I need to do to open the encrypted file from the site itself?

I am looking for some help to let Alteryx to read and output password protected Excel Files. Besides using R or Python, look like there're old discussions on using a macro. However, look like that macro was taken off the shelf some time ago.

Thank you. The macro runs with no error. However, the macro automatically open the password protected file and then prompt to enter the password. and the output anchor of the macro isn't showing the data on the Excel tab.

Anything I am doing wrong here. I thought the password can be entered as a string in workflow so the macro can absorb the relevant information such as file path, file name and password and then output the data for further analysis.

Thank you for sharing this tool, I'd been using it on several workflows for a couple of weeks now. However, all of them stopped working out of nowhere, even though I made no changes to the workflows. Do you have any idea of what could have happened?

Hi, thanks for the response. I'm using the Python solution. It had been working perfeclty by removing the password, runing the rest of the workflow and then protecting the file again. But now, when I run the workflows I get the message that "Password Removal Failed" from the Python tool.

I would like to use workflow in Alteryx for a number of excels with password, so I prefer possibility to remove password/or possibility to read such file in Alteryx, rather than remove password in Excel every time I want to run workflow.

Nevertheless, I seem to be hitting a road block since when I click on Run, it flows to the R tool where it stays at 50% and this thing happens: these characters come one after another in a loop \ / - no error, no nothing. I attach printscreen.

P.S. As I was writing this, suddenly my excel file opened on my computer, outside Alteryx and it prompted the little window for the password. The percentage in Alteryx stayed at 50% still looping through those characters.

@RishiK thank you for providing the details and sample workflow. I've followed your example but run into a "There was an error in WriteYXDBStreaming" error. Any thoughts on how to resolve this? I'm running Alteryx 2020.3.5

I'm reaching out to the community for some assistance with a PDF issue I'm facing. I have a PDF document that is password protected, and unfortunately, I no longer have the password. I'm looking for a way to access this document without the password.

1. PDF Password Recovery software: This type of software application is used for recovering lost passwords for PDF files. One good example is iSeePassword Dr.PDF. It's designed to recover different types of PDF passwords including user password and owner password. The amazing tool is user-friendly and comes with a simple interface that requires no technical knowledge or expertise to use. The screenshot is one successful case. Below is a step-by-step guide for opening password protected PDF file with Dr.PDF software:

2. Adobe Acrobat: If you have an Adobe Acrobat subscription, you can use it to open password-protected PDFs. Adobe Acrobat has a feature called "remove password" that allows you to remove the password protection from a PDF file.

3. Online Password Recovery Services: Some online services offer password recovery for PDF files. These services require you to upload the file, and they will attempt to recover the password for you. Examples include LostMyPass and PDF Unlocker. Be cautious when using such services and ensure that they are reputable and trustworthy. After you have finished all your work, remember to delete all browsing history so that the data is not prying eyes.

I'm trying to open a password protected file in excel without any user interaction. I searched online, and found this code which uses win32com.clientWhen I run this, I still get the prompt to enter the password...

Or, you could use msoffcrypto-tool as a library. While you could write an unencrypted version to disk like above, you may prefer to create an decrypted in-memory file and pass this to your Python Excel library (openpyxl, xlrd, etc.).

Thank you so much for the great answers on this topic. Trying to collate all of it. My requirement was to open a bunch of password protected excel files ( all had same password ) so that I could do some more processing on those. Please find the code below.

Hello,
with KNIME Analytics Platform 4.4 (which will be released this summer) the Excel Reader will support reading password protected files (internal ticket number ist AP-13961).
This is already implemented and available in the nightly build. Once you have installed the nightly build configure the Excel Reader as always and then go to the Encryption tab to enter the password.
Let us know if you encounter any problems with it.
Bye
Tobias

I have an xlsx file that has been created with Microsoft Office Word and password protected. After that, I started open and edit it with LO 6.0.1. When I opened it in LO it asked me for the password only for the first time. After that, it never asked me again when I open the file.

Thanks a lot for your precious help. In fact, your solution was the right one since my password has 23 characters. I simply inputted the first 15 has suggested and magically it opened immediately. I have already tried it in LO 6.4 with a password bigger than 15 characters and the problem have already been corrected has said.

The only possible solution I can see is if the Caps Lock was set when you entered your password. If you have a small keyboard without separate numeric keypad (typically a laptop computer), Num Lock may also have come into play.

I have Adobe CS5 on my laptop (Paid for and registered), but when I open a deceased's password protected medical doc, I get the error msg "There was an error opening this document. An updated version of Acrobat is needed in order to open this document" . I have have kept Adobe Acrobat Pro updated. When I open the doc on another computer with only Adobe reader (No Adobe Acrobat Pro), I have no issues opening the Doc with the password. Adobe reader even opens the password Doc on my phone. CS5 will not let me have Reader as and extra PDF program. This is frustrating as the online chat help takes me nowhere

The main change in PDF encryption in the recent years was the introduction of AES256 support, first as a proprietary implementation by Adobe, later with some changes as part of the PDF standard. So I assume those medical docs are AES256 encrypted.

Adobe Acrobat 9 is from times before AES256 encryption was introduced in the PDF standard. Non-proprietary AES256 encryption was specified in ISO 32000-2 in 2017 while support for Acrobat 9 ended 2013. Thus, there is no reason to assume that Acrobat 9

Adobe Acrobat 9 is from times before AES256 encryption was introduced in the PDF standard. Non-proprietary AES256 encryption was specified in ISO 32000-2 in 2017 while support for Acrobat 9 ended 2013. Thus, there is no reason to assume that Acrobat 9 could somehow support AES256 encryption.

I have a password-protected .ods file that was made in LibreOffice. I have since moved to using Microsoft Excel, and whenever I try to open the file I get the error message: "Cannot open: the file has been protected with a password and cannot be opened."

I suggest that you open the spreadsheet in LibreOffice using the password, then save it in Office format (.xls or .xlsx, depending on the version of Excel you wish to use it in). The spreadsheet should then be accessible by your version of Excel, but bear in mind that the password will be removed by this action in some versions of Excel (2016, in my case) and will need to be re-done if protection is needed.

We have a VI that I went to update from version 7.x to 2009SP1. I need to add some troubleshotting items to the front panel. The problem is that the VI is password protected and no one remembers the password, just possible passwords.

c01484d022