cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Announcements
If you’ve changed your email address, now's the perfect time to update it on your Dropbox account and we’re here to help! Learn more here.

View, download, and export

Need support with viewing, downloading, and exporting files and folders from your Dropbox account? Find help from the Dropbox Community.

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

Excel files automatically open as Google Sheet on site

Excel files automatically open as Google Sheet on site

Sam Bestov
Explorer | Level 4

Hi Everyone,

 

When viewing an excel sheet in Dropbox it automatically opens as a Google Sheets doc.

Also when you share the link, anyone clicking it will automatically see it a Google Sheets doc.

Is there a way to set it to Microsoft 365 as default?

 

I have changed the settings in the Default Editing Apps section to "excel for the web" but that doesn't seem to fix it.

 

The reason why I'd like to change it, is because I use the European date-notation (DD/MM/YYYY) in my documents and Dropbox/Google Sheets sets it to the US notation (MM/DD/YYYY). When sharing the documents with others, I really want to avoid any confusion.

 

Thanks!

 

Sam

9 Replies 9

Sam Bestov
Explorer | Level 4

EDIT: It is not Google Sheet it opens in, but the 'Dropbox preview'.

Jay
Dropbox Staff

Hi @Sam Bestov, thanks for messaging the Community!

 

Could you doublecheck again the setting you have on this page for default editing apps on your account?

 

This will help me to assist further!


Jay
Community Moderator @ Dropbox
dropbox.com/support


Heart Did this post help you? If so, give it a Like below to let us know.
:arrows_counterclockwise: Need help with something else? Ask me a question!
:pushpin: Find Tips & Tricks Discover more ways to use Dropbox here!
:arrows_counterclockwise: Interested in Community Groups? Click here to join!

Sam Bestov
Explorer | Level 4

Hi Jay,

 

Thanks for reaching out, for Word & Excel the settings are:

 

"Word on the web"

"Excel on the web"

 

Powerpoint I didn't change yet.

 

Best

 

Sam

 

 

Jay
Dropbox Staff

Are you viewing these files while logged into your own account, or is it via a shared link?

 

Could you attach a screenshot showing the file in the folder it's in, and then after you open the file (while hiding any personal info)?


Jay
Community Moderator @ Dropbox
dropbox.com/support


Heart Did this post help you? If so, give it a Like below to let us know.
:arrows_counterclockwise: Need help with something else? Ask me a question!
:pushpin: Find Tips & Tricks Discover more ways to use Dropbox here!
:arrows_counterclockwise: Interested in Community Groups? Click here to join!

Sam Bestov
Explorer | Level 4

Hi Jay,

 

We were able to fix the problem within our team. The files I was refering too weren't mine, but my colleagues who's deafult apps weren't set to Microsoft. The files, when used within our team, open in an 'Excel for Web' format.

 

But when sharing a link with people outside of our team, it seems it still opens the file in a Dropbox-viewer format, with the wrong date-notation.

 

I've included screenshots of the file:

 

- in the folder

- as seen by our team

- as seen by 'outsiders'

 

Thanks again!

 

Best

 

Sam

 

[Removed as per Community Guidelines]

Jay
Dropbox Staff

Thanks for the images, I've removed them for your own privacy and security.

 

I did a test on my end and the Excel file previewed the files normally, with the dates in the correct order. 

 

Do you know if the file itself in its properties is set to your location with DD/MM/YYYY as the year format?


Jay
Community Moderator @ Dropbox
dropbox.com/support


Heart Did this post help you? If so, give it a Like below to let us know.
:arrows_counterclockwise: Need help with something else? Ask me a question!
:pushpin: Find Tips & Tricks Discover more ways to use Dropbox here!
:arrows_counterclockwise: Interested in Community Groups? Click here to join!

Sam Bestov
Explorer | Level 4

Just to make sure, with your preview, you mean a Dropbox-preview?

 

Cause the Dropbox preview, when logged into our account, also show the date as MM/DD/YYYY (print screen)

 

In the file the date properties are set to DD/MM/YYY.

And as said before, when the link is shared with someone outside the team, it also shows MM/DD/YYYY 

 

Thanks again Jay!

 

Folder PreviewFolder Preview

 

Jay
Dropbox Staff

Yes, with the Dropbox preview page, it shows the correct format.

 

I'd recommend contacting the support team to see if they can provide any specific information regarding this matter for your account.


Jay
Community Moderator @ Dropbox
dropbox.com/support


Heart Did this post help you? If so, give it a Like below to let us know.
:arrows_counterclockwise: Need help with something else? Ask me a question!
:pushpin: Find Tips & Tricks Discover more ways to use Dropbox here!
:arrows_counterclockwise: Interested in Community Groups? Click here to join!

Sam Bestov
Explorer | Level 4

Okay, will do.

Thanks a million Jay!

Need more support?
Who's talking

Top contributors to this post

  • User avatar
    Sam Bestov Explorer | Level 4
  • User avatar
    Jay Dropbox Staff
What do Dropbox user levels mean?