Can't edit Microsoft files on iPhone (iOS 18)

Hello, I had same problem.
Try to edit pptx from app Files, then mode changed from view to edit too.

Hey JanWig, I hope it's okay for me to jump in here as well.

I'm afraid that if the files need to open through OneDrive, there's no way to adjust things through Dropbox, in order for you to edit them.

OneDrive is a third party app that cannot be linked with Dropbox.

If there's a way for your Microsoft files in Dropbox to open with their respective Office apps and not with OneDrive, this should work, but not with the current situation.

I hope this clarifies things and if you have any more questions, feel free to let us know.

Dear Megan

You are right.

My problem is: On my iPhone I cannot open and edit Microsoft files that are stored in Dropbox . My phone also have the apps OneDrive and Microsoft365

During trouble shooting I have tried several things (apart from reinstalling Dropbox)

I copied (using my PC) some Microsoft files  from Dropbox and stored them in: 1. My OneDrive    2. My wife's Dropbox. 

Results:

On my phone: 1. The files work fine when I open (clicked) directly from OneDrive (when it is stored in OneDrive) => Nothing wrong with the files. 2. The files work fine when I open them from the Excel app (files stored in Dropbox). 3. I cannot open and edit the files when I open them directly from Dropbox (files stored in Dropbox). This is when I get the error message that the storage location is not supported (see screenshots above)

On my wife's iPAD (that does not have OneDrive installed, but Microsoft365):  The files work fine when I open (click) directly from Dropbox (files stored in Dropbox).

Conclusion: The OneDrive app causes the problem. Microsoft told me that if I have OneDrive installed any Microsoft file will be opened via OneDrive regardless where the files are stored. Thus my conclusion is that there is a bug in the communication between Dropbox and OneDrive ( or a setting somewhere that can be adjusted). Let me know your thoughts!

Hey JanWig, thanks for testing this!

Just to make sure we're on the same page here, and that I've gathered all the necessary info:  Is the example file located to Dropbox? It sounds like you access your Dropbox app on your iPhone, locate a Microsoft file and try to open it using the respective app.

When that happens you get the error message, right? If not, feel free to correct me. I just need to make sure because you also mentioned that you open the files using OneDrive. Are they located there too?

If you open Excel, and try to locate a Dropbox file in order to open it, does it work? 

Hey Megan

I understand that this would be a good trial for troubleshooting, but that is a quite big "operation", that I hesitate to do, since OneDrive is working flawless and a  major feature in my phone.

Especially since I have not done any changes, and this just suddenly stopped working. 

However, I sent an .xlsx file (that can not be edited in my phone) to my wife's older iPAD and stored the file in her Dropbox.

That iPAD does not have OneDrive but Excel version 2.77 and iOS15.8.3. I can open and edit the xlsx.file. The Dropbox version was just updated (but remember it is an old iOS version).

I also tried to share to her new iPAD (that has OneDrive), but not Dropbox. It works (she can open and edit from OneDrive) when I share a file directly from my Dropbox to her OneDrive (Microsoft365). 

I suggest that the problem is a bug on the Dropboxside that messes up the Dropbox Microsoft-file when communicating (being opened) with OneDrive. I do not know how to change setting to avoid using OneDrive when opening a Microsoft file. Maybe you know? As I said above Microsoft said that it always uses OneDrive to open a file, if One Drive is there. I do use the OneDrive cloud.

Whether this bug is on your end or on Microsoft end I am not the expert to conclude. I suggest, though, that Apple (iOS), as was suggested by your collegue is not really involved, but of course I am a complete amateur.

Please advice

Hey JanWig, let me jump in here too! 

I believe my colleague, Jay was talking about OneDrive. Specifically changing any setting that might prevent files from opening directly through Dropbox.

However, I'd like for us to try one more thing, if you don't mind: if you temporarily remove OneDrive from your iPhone, and try to open the same Excel files through Dropbox, do you get the same results? If you could try this, that'd be ideal, if not let me know. 

This will help us get a better idea as to what might be causing this error, and if the third-party app is playing a part in this. 

Hm….So this is new then either a change by Dropbox or by Microsoft, since it has been working fine for several years now.

Which app do you mean when you state: “…you’ll need to remove that default setting from within the iOSsystem as this appears to be created by that app”

I do not understand what the difference is when opening the same file from OneDrive vs Dropbox. It works fine to open from One drive but not from Dropbox. For both occasions it always starts by opening the OneDrive app.

I talked to Microsoft a day ago and they said that whenever one opens a Microsoft (365) file (xlsx, docx pptx etc) it always starts by opening OneDrive.  I can definitely confirm this. This then means, as I interpret,  that this is rather linked to Dropbox rather than iOS. 

What you now are saying is that I should talk to Apple, since you mean this is an iOS setting. I doubt this, I must say, but I will contact Applesupport and ask them. I cannot see how they are involved here though, but I am not an expert.

The most likely solution for me is to give up Dropbox and work from OneDrive.

If the Dropbox app is automatically opening the OneDrive app, then you'll need to remove that default opening setting from within the iOS system, as this appears to be a setting created by that app.

 I have now uninstalled, rebooted my phone and reinstalled Dropbox.

Unfortunately no change. The .xlsx files can be opened but not for editing. No links in the excelfile is working. .docx files and .pptx files same thing. Can be opened and viewed but not edited. Same error and same error messages.

After copying the files into OneDrive (on my PC)  I can open and edit from there.

On the PC everything works fine from Dropbox, I.e. I can open and edit.