We Want to Hear From You! What Do You Want to See on the Community? Tell us here!

Forum Discussion

Sam Bestov's avatar
Sam Bestov
Explorer | Level 4
2 years ago

Excel files automatically open as Google Sheet on site

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

Replies have been turned off for this discussion
  • Sam Bestov's avatar
    Sam Bestov
    Explorer | Level 4
    2 years ago

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

  • Jay's avatar
    Jay
    Icon for Dropbox Community Moderator rankDropbox Community Moderator
    2 years ago

    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!

  • Sam Bestov's avatar
    Sam Bestov
    Explorer | Level 4
    2 years ago

    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's avatar
    Jay
    Icon for Dropbox Community Moderator rankDropbox Community Moderator
    2 years ago

    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)?

  • Sam Bestov's avatar
    Sam Bestov
    Explorer | Level 4
    2 years ago

    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's avatar
    Jay
    Icon for Dropbox Community Moderator rankDropbox Community Moderator
    2 years ago

    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?

  • Sam Bestov's avatar
    Sam Bestov
    Explorer | Level 4
    2 years ago

    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 Preview

     

  • Jay's avatar
    Jay
    Icon for Dropbox Community Moderator rankDropbox Community Moderator
    2 years ago

    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.

About View, download, and export

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

Need More Support

The Dropbox Community team is active from Monday to Friday. We try to respond to you as soon as we can, usually within 2 hours.

If you need more help you can view your support options (expected response time for an email or ticket is 24 hours), or contact us on X or Facebook.

For more info on available support options for your Dropbox plan, see this article.

If you found the answer to your question in this Community thread, please 'like' the post to say thanks and to let us know it was useful!