Child Item

WOPI Version of .xlsm files opening in Desktop App. Why is this happening?

Hello,

With zero support from Dropbox Advanced support, I'm hoping as a community anyone can provide some guidance. I have a user in my organization who in the desktop app cannot open and edit xlsm files, no one else in our organization has this issue. According to ChatGPT, the file(s) and not corrupted and it is not a Microsoft issue. All xlsm files for this user are offline files. I employed autoruns and unchecked some Dropbox extensions to force open xlsm files as 'local' files without Dropbox trying to open the WOPI version, which is unusable. We have thousands xlsm files we use daily, and cannot nor should have to copy each file over to this users' desktop and copy them back to the desktop app as that is a huge waste of time. I'm confused why he is the only user that is impacted this way and hoping someone can provide some solutions so this user can use xlsm files in the desktop just like the rest of us.

Thank you in advanced.

Find more posts tagged with

Desktop

Microsoft Office

Preview

Insightful

New Ideation Status

Accepted answers

Matt_001

Hi Jon,

Thank you for writing this, we were able to find a solution to the almost exact issue. For anyone that runs into this issue, "Dropbox for Teams" can be found using the instructions below:

Open New Excel
Click Account in the bottom left corner
Located Connected Services in the bottom left section
Remove Dropbox for Teams

All comments

Megan

Hey @hshupe16, let's jump right into this!

Does this only happen when the user is trying to open .xlsm files? Do you notice the same behavior with other files too?

I'd love to know an estimate as to when this started happening.

You also mentioned that the files are offline. Do you mean they're available offline, or online only, and if so have you tried changing their status to see if you notice any difference?

Lastly, you mentioned you've reached out to our Support team. Can you share your ticket number reference with me, in order to locate it on our system?

Keep me posted, and we'll take it from there!

hshupe16

Here is my ticking reference Ticket #24999726

This started happening Friday but with ChatGPT I was able to solve it my turning off the extension to excel for this user as all xlsm files are offline not online-only. Is this a permeant fix I am not sure but now for this user xlsm files open with ease in the desktop app.

Walter

Thanks for the ticket ID @hshupe16 - I was able to locate it in our system and pass your comments on so that we can have all the relevant information under one place.

Apart from that, I'm glad to hear you managed to sort it out in the end and thanks for keeping us in the loop too!

Jon_DFH

I have one user that I just setup a new PC for that is having this issue. Seems that opening Excel files causes this "https://wopi.dropbox.com/wopi/files...[file name].xlsx" is open in another application error. Never had this with any other user and I'm struggling for a solution at this point. The only way to open files is to force close the dropbox app, open the file, then open the dropbox app again; which is not exactly convenient.

It sounds like this has something to do with co-authoring, which I never explicitly turned on. Would like to know if there is a way to disable this from the admin side so none of my users have this problem.

Jay

Hi @Jon_DFH, could you clarify exactly how the user is opening the file from the following options:

Within the Excel app by navigating to the file
Selecting it from the Recent files page in Excel
Double clicking the file in the Dropbox folder
Or, some other method

This info will help us out!

Jon_DFH

Double clicking on the file through the Dropbox folder. We have our files set to online-only by default. I set ever PC up exactly the same and this is the first time I've ever seen this error.

Jay

Could you try marking the file as available offline/local to see if there are any changes when opening the file?

If you believe you enabled co-authoring, have you tried disabling it to see if this helps?

Jon_DFH

We did try marking as local with the same error message. I have not changed anything on the admin side, so as far as I know co-authoring was never turned on.

I just went ahead and set all the Microsoft apps to "block" though as a precaution. Is there anything local for this user I need to do to disable co-authoring?

Jay

There shouldn't be any local options, as co-authoring is disabled from the admin console, which would disable it for the whole team.

Jon_DFH

Looks like at some point "Dropbox for Teams" was added as a connected service in Office 365. Not sure why. Removing that looks like it solved the issue. Doesn't sound like whatever that service is works properly.

Grinch

I open Dropbox and open the excel file. Then I try Open in Excel. I get message Can’t open Excel File.

Megan

Hey @Grinch, thanks for posting here today!

When did you first notice this behavior? I'm also guessing you're also using our desktop app like the OP mentioned, right?

Does this happen with all of your Excel files, or some of them? I'd love to know any troubleshooting steps you've tried so far, in order for us to be aligned.

Thanks a bunch!

Megan

Hey @Grinch!

Just popping in to see if you've had a chance to look at our last message. Still need help? We're all ears! If the issue is sorted, let us know what worked out for you.

Matt_001

Hi Jon,

Thank you for writing this, we were able to find a solution to the almost exact issue. For anyone that runs into this issue, "Dropbox for Teams" can be found using the instructions below:

Open New Excel
Click Account in the bottom left corner
Located Connected Services in the bottom left section
Remove Dropbox for Teams

UPLE

Thx a lot !!!! I have removed the "Dropbox for Teams" and the WOPI url as gone ! Big up Jon