Child Item

We've shared an Excel file with other users, but they can't edit it in Excel

When someone opens a dropbox excel file that has been shared with them, it seems they are not able to edit in excel, unless they download it, or save via dropbox. How would someone be able to edit the file and have it show up for everyone that the file is shared with?

Find more posts tagged with

Microsoft Office

Edit

Developer

New Ideation Status

Accepted answers

Rich

@Jalby wrote:
I did to my knowledge share it with edit rights. My screen looks like this next to the "Who can access" screen.

Does the file appear for them on this page?

https://www.dropbox.com/share/files

This really is much easier when the file is placed in a folder and you share the folder rather than the file itself. You invite them to the folder, they accept and it's added to their account, then any changes made within that folder sync for all members of the folder. There's far less confusion over shared links and whether or not a person has view or edit access.

All comments

Mark

Unless they have a Dropbox account they wouldnt be able to do this. Sharing links to none Dropbox members creates a read only link.

They need to edit the file and edit it within Dropbox for others to see it - either Excel on web (when logged in) or by downloading and uploading again.

Jalby

They have a free dropbox account, does that not work?

Mark

Yes. So they need to log on and accept the share via the email they are sent, or, at www.dropbox.com/share

Jalby

Okay, thank you. I thought that would work too but all they're able to do from there is download, and then it downloads on their phone but they aren't able to upload it via the Dropbox app or if they export it or save it to their phone and open it via excel that way, it creates a copy.

Rich

@Jalby wrote:
... all they're able to do from there is download, and then it downloads on their phone but they aren't able to upload it via the Dropbox app ...

It sounds like you used a view-only shared link, rather than an edit link or inviting them into a shared folder that contained the file. A view-only shared link would only allow someone to view or download a file, or save it to their own Dropbox, and they would not be able to make changes to your original file nor upload back to your account.

You need to use a shared link with edit access, or place the file in a folder and share the folder with edit access.

Jalby

Thank you for your help! I did to my knowledge share it with edit rights. My screen looks like this next to the "Who can access" screen.

Rich

@Jalby wrote:
I did to my knowledge share it with edit rights. My screen looks like this next to the "Who can access" screen.

Does the file appear for them on this page?

https://www.dropbox.com/share/files

Jalby

Gotcha. Yes, it does pop up there but only has an option to download. It seems to be working when someone edits on a computer but not on a phone. We might have to create separate folders then. We just didn't want them to have access to the other files in that folder.

Jalby

I created separate folders and it worked! Thank you so much.