cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Announcements
Update: Find information on Dropbox support during COVID-19 here
Close

Dropbox files & folders

Get in sync with the Dropbox Community. Our users can answer all of your questions on files and folders. Join a discussion or start your own.

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Highlighted

Open link in Excel or at least find where it is located

Explorer | Level 3

I have a link to an Excel file

 

(a) I want to open it in Excel, not the web version. I use custom settings in Office applications due to visual impairments. I actually always want to open files in the desktop versions of office tools. How do I do this?

(b) If I click the link, it opens the file in the web version of Excel. How do I find out where the file is within Dropbox, so I can navigate to it and open it properly?

 

Many thanks.

8 Replies 8
Highlighted

Re: Open link in Excel or at least find where it is located

Dropboxer
Dropboxer

Hello @HerrGrey, thanks for reaching out to us here!

 

Just to clarify, is this a shared link to a file that already exists within your Dropbox account? If not, you'll need to save it to your account first by clicking on the ellipsis towards the top right corner of the webpage and choosing "Save to Dropbox".

 

To be able to open the file locally from the website, you will need to have the desktop app installed on your computer and the file you want to open synced locally.

 

When you open the link to the file, can you try clicking the "Open" button in the top right of the web page and let me know if you see the option to open with the local Excel app?

 

If you don't have the desktop app installed on your computer, then you will need to download the file to your computer, edit it in the local Excel app and then re-upload it to your account.

 

Let me know and we can go from there!


Daphne
Community Moderator @ Dropbox
https://dropbox.com/support


Heart Did this post help you? If so, please give it a Like below.
Still stuck? Ask me a question!
Tips & Tricks Find new ways to stay in flow or share your tips on how you work smarter with Dropbox.

Highlighted

Re: Open link in Excel or at least find where it is located

Explorer | Level 3

This is a link sent from another person who is a member of the same business account.

 

The first problem is that the link path is garbled text, so I can't see where the file is physically located within the database. How do I find out where the file is in order to sync it?

 

If I click the link, it opens Excel in the browser and I don't see an "Open" button in the top right of the web page.

 

Highlighted

Re: Open link in Excel or at least find where it is located

Dropboxer
Dropboxer

Thanks for getting back to me @HerrGrey!

 

If the file is opening directly in Excel Online, this may be due to the default apps you've selected in your account settings. 

 

Can you check from here if you have the option set to "Excel for the web" for Excel workbooks? If so, please try changing this to "View on dropbox.com".

 

Now, when you open the link again it should open the preview of the file in your account with a pop up prompt asking if you want to open it in Excel Online. Please dismiss this prompt with the "x" in the top right corner.

 

From here, you should be able to click the "Back" arrow in the top left corner, which will take you to the folder the file is located in. Hopefully this will help you to find where this file is located in your account. 

 

Also, from that preview page, you should be able to see the Open button now, and see if you can open it locally with the option "Open in Microsoft Excel".

 

Let me know how it goes!


Daphne
Community Moderator @ Dropbox
https://dropbox.com/support


Heart Did this post help you? If so, please give it a Like below.
Still stuck? Ask me a question!
Tips & Tricks Find new ways to stay in flow or share your tips on how you work smarter with Dropbox.

Highlighted

Re: Open link in Excel or at least find where it is located

Explorer | Level 3

Hello,

 

I don't have the option to "Open in Microsoft Excel" only "Excel for Web" or "Google Sheets" is shown. (I do have a full office installation).

Highlighted

Re: Open link in Excel or at least find where it is located

Dropboxer
Dropboxer

Hmm... I see.

 

Were you able to locate where this file is located in your account? Do you have this file synced locally in your Dropbox folder on your computer via the desktop app?

 

Also, can you let me know which web browser and version you're currently using?


Daphne
Community Moderator @ Dropbox
https://dropbox.com/support


Heart Did this post help you? If so, please give it a Like below.
Still stuck? Ask me a question!
Tips & Tricks Find new ways to stay in flow or share your tips on how you work smarter with Dropbox.

Highlighted

Re: Open link in Excel or at least find where it is located

Explorer | Level 3

I located it and it's locally sync'd.

I'm using Firefox.

The web interface does not present me the option to open using Excel. But if I navigate (using File Explorer) to the Dropbox folder then I can obviously open the file in Excel.

 

 

 

Highlighted

Re: Open link in Excel or at least find where it is located

Dropboxer
Dropboxer

That's great, thanks for confirming that @HerrGrey!

 

It may take a moment or two for the local options to appear, so when you click the open button, please try it again after a minute too to see if there was a delay in the option showing.

 

If not, since you're using Firefox you'll need to have Flash Player version 10 or later installed and enabled for the Dropbox website which you can do through your browser settings.

 

The desktop app will also need access to certain ports for this integration to work too. I'd suggest checking the section regarding this towards the bottom of this article for more info.

 

Out of curiosity, do you have another web browser installed on your computer that you could try this out with too?

 

You'd need to be signed into your Dropbox account when opening the link in that browser too, but this will give us an idea if the requirements are there on the desktop app side.


Daphne
Community Moderator @ Dropbox
https://dropbox.com/support


Heart Did this post help you? If so, please give it a Like below.
Still stuck? Ask me a question!
Tips & Tricks Find new ways to stay in flow or share your tips on how you work smarter with Dropbox.

Highlighted

Re: Open link in Excel or at least find where it is located

Explorer | Level 3

Hello,

  • I am using Windows 10.
  • I have installed latest Flash Player.
    • 'Open in Excel' does not appear on the menu.
  • I tried using Edge instead of Firefox
    • 'Open in Excel' also does not appear on the menu.
  • I use KAV but I don't alter AV settings to exclude applications (because I would be creating a vulnerability)

 

I cannot use the Word/Excel/Powerpoint versions 'for web', because they do not load my settings (for my visual impairment) so I am happy to lose those applications if that would work.

 

If I go to any website that has an Excel, Word or PPT file and if I click the link, I am prompted whether I want to 'Save' or 'Open with Excel' or 'Open with Other...'. That behaviour is perfect for anyone with disabilities. But Dropbox seems to be 'different' to normal, can I get that same behaviour with Dropbox?

 

Work Smarter with Dropbox

The way we work is changing. Share and discover new ways to work smarter with Dropbox in our community.

Sound good? Let's get started.
Polls
Have you been keeping up good habits while working from home?
We've created a working from home cheat sheet to help keep up on those habits, check it out here.
Need more support?