Announcements
Known issues updated. Learn more

default

yes

Incorrect datetime in Excel preview mode

Explorer | Level 3

I'm using Dropbox with a lot of Excell-sheets.

In one of those sheets, there's a function with a dependancy to now().

The weird thing is that when I preview the sheet, the date is off by a couple of days in the past, but when I open it (be it in Excel-Online or through Excell on my computer), it shows the date correct. After saving, and previoew again: back to a few day's in the past.

Preview.jpgEdit.jpg

Any suggestions?

1 Reply
Highlighted

Re: Incorrect datetime in Excel preview mode

Dropboxer
Hey there (@miura), thanks for this detailed description & the screenshot of what this looks like on your end! 
 
Kindly bear in mind that this is happening because the preview is generated at the time the file is uploaded & we’re unable to provide the use of functions/formulas when previewing files. As I understand that you're (in all likelihood) interested in this functionality, I’ve made a brief note of your thoughts & in my feedback report for further consideration. 
 
I hope that this answers your initial question & I’m always here in case you have any more queries! 

 


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


 


Heart Did this post help you? If so please give it a Like below. 
White check mark Did this post fix your issue/answer your question? If so please press the 'Accept as Best Answer' button to help others find it.
Arrows Counter Clock Still stuck? Ask me a question! (
Questions asked in the community will likely receive an answer within 4 hours!)

Reply
Loading...
Installation and Desktop App Issues

Have a question? Our Dropbox Community is here to help!

Post your question or search for an answer below.


Learn more about using the Community by reading our Community Guidelines.


Hi anonymous,

If you need more help you can log a ticket with our Support Team here (expected response time 24 hours), or contact us on Twitter or Facebook.

For more info on available support options, see this article.

If you found the answer to your question, please 'like' the post to say thanks to the user!

Incorrect datetime in Excel preview mode
351 Views
1 Reply
1 Like
Solved! : See solution