Error message: Decryption failed(null) when attempting to open an Excel document on iPad

I am receiving the error message: Decryption failed(null) when attempting to open a password protected Excel document on iPhone and iPad after update to ios 14.2

iPhone 11, iOS 14

Posted on Nov 10, 2020 3:32 PM

Reply
Question marked as Top-ranking reply

Posted on Nov 20, 2020 7:22 AM

Interim Success

 

Ok, I've found an interim solution though I still believe Apple has an issue since I have read that 14.1 does not have this problem but at least this works for now.. .. and don't believe that the issue lies with Dropbox, Synology DS File, Microsoft, etc, the issue is with Apple and they need to fix what they broke.


I took the Excel password protected file that I could not open directly from with the Apple Mail app on my iPhone 12 running iOS 14.2 (the same exact file worked fine in 13.6) and instead of opening it, I long pressed it in Mail until I got a pop up menu with choices. I like choices :-) I chose to Save that file in the Apple "Files" app on my phone. The File app comes standard with iOS. I then opened the Files app and tapped the password protected Excel file I just put there, it prompted for a password, I entered it and it opened just fine. 

However, in order to get success, you first have to go to the Apple App store and download the free "Microsoft Office app for iOS", (see pic). Once downloaded to your phone you do not need to sign in to it or even have it open, just the fact that its on the same device as the file you want to open does the trick. The Excel file opened it in Excel.

 

I will assume this same procedure will work for Word and Powerpoint but haven't tried it yet.

 

So until Apple fixes the issue, there is another way to open a password protected Microsoft Office file on an iOS device running iOS 14.2


284 replies

Nov 30, 2020 1:50 PM in response to appbag

The good news is, I can now open my Excel files on both iPad and on iPhone 12pro. My question may now go to Dropbox—I wonder why I still receive the Decryption failed (null) message above the invitation to “open” the file in Excel. I used to get a preview copy of the Excel file before I actually opened the Excel file for editing. This is not a real problem—but I’m curious if the change lives with Dropbox? Apple? or Microsoft? Anyway, I’m relieved I can now go directly to opening the Excel files.

Dec 3, 2020 2:58 PM in response to Bgnmarty

Bgnmarty, thank you! I think you have summarized the situation perfectly! It had not occurred to me that maybe this is an intentional change—I hope not, but you may have given the ‘real’ answer to the issue. I like the convenience of preview, but fear I may have to get used to the new way of things. Anyway, thank you for reviewing the issue so carefully. Nice job.

Dec 7, 2020 11:00 AM in response to PatAnn918

Thanks for the compliment, glad it helped. The only way Apple can fix the issue is to release another version of iOS. Not sure why some people think Apple can magically jump onto their phone and fix it without changing the software level. I know iOS 14.2.1 did not fix it so am waiting for their next release. However, keep in mind they may have done this intentionally, ha...we may not get an Apple fix :-0 Time will tell.

Dec 8, 2020 5:15 AM in response to DavidRyer

Yes I know, I saw that too but its not solved until Apple solves it via an iOS update. It appears the algorithm on this form for marking something solved needs a bit of attention. I've seen myself where I thought I solved a certain issue only to find out a day or so later that my solution was not robust enough to withstand all the various ways the issue can happen. I looked at the settings on this forum and could not find a way to remove the Solved marking on that post.


All we have to date is a good work around.

Dec 9, 2020 12:18 PM in response to Bgnmarty

This did not work for me. I’m trying to open a password-protected Word doc. I saved the doc to the documents folder and then downloaded the Microsoft Office app. I still get the Decryption failed (null) message when I try to open from the email directly. When I try to open from the saved document I just get a blank page. Any ideas? TIA.


F/U: opened MS Office app and was able to search for the saved doc and it did open from there. Is there any way to open it direct from the email until Apple fixes this bug?

TY

Dec 14, 2020 1:03 PM in response to cvdinh

You're welcome cvdinh & AZTechGirl,

Glad the work around helps. BTW, I was on the phone with Apple senior support again on this issue doing some ancillary testing with password protected MS files and we both came to a preliminary conclusion that this change may not be accidental :-0 We won't know till a couple more iOS upgrades are released but it does seem to fit the path Apple is taking on third party apps. I'm actually starting to like the work around better and it only takes one second to open the file.

Jan 2, 2021 7:23 AM in response to Bgnmarty

I don't know how Microsoft decide to released app for phone or tablet but the positive side of Excel now is that you can mod the file directly from iPhone. I use a file for passwords.. is not simple to type on 5" screen display but now i have the file in iCloud and is immediately available from iPhone, Mac or iPad.

And is one update anytime. Before I had to delete the pdf and create a new one everytime I insert a new pass because pdf are not editable. Now is only one file everywhere

Jan 2, 2021 9:37 AM in response to appbag

I have the same issue with the iPhone 12 Pro that i just purchased. I have been a long time Android Samsung Galaxy user but I was forced into a situation where i had to switch to the iPhone. On my Samsung device, I have been able to store password protected Excel files within Dropbox, as well as using another third party encryption program to further protect the files. When I discovered on that platform that I was receiving errors opening the Excel file (using the Excel app), I switched to OfficeSuite and found that this program worked flawlessly.


Fortunately on the Samsung phone, I had the choice of which application to use to open the file. I am not getting the same option on the iPhone, even though I have installed the same paid version apps. Let's see if they can resolve this issue soon!

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Error message: Decryption failed(null) when attempting to open an Excel document on iPad

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.