I have similar issue. Note the following differences:
- I am trying to open .xlsx file from my box.com account, rather than onedrive
- I don't believe I have or had any password protections on this file
- I, too, was able to open the file from the Office (Not Excel) app on my Android 5.0, but
It didn't seem to open until after I started to back out of the app (or it just took that long to open the file
I received an error stating that I "cannot edit the file" when I tried to sort the spreadsheet
App store states that Office app is intended or supports only Android 4.4 or earlier and that I should use Excel, word, etc. apps for my newer Android OS' (I have Android 5.0)
- I receive two pop-up messages as I try to open file
First, asking me to confirm that I trust the file's author (I said yes, since I'm the author!)
Second, telling me Excel cannot open the file
No further help or clues about the issue
- Sadly, I can open the file from box on several other spreadsheet apps and, so far, only Excel fails to open this Excel file! None of the apps can both sort and filter columns, both of which I would like to do and assume/hope that the Excel app can/should
be able to do for an Excel file.
- I was able to open another .xlsx file from Box via Excel app on my Android 5.0 samsung phone (same device, app, source and folder within Box)