Forum Discussion
Creating a static time stamp in Excel online version
Excel Online has no option to switch-on iterative calculations which are required for time stamp trick. VBA doesn't work on Excel Online and I'm not sure if Office Script could be triggered by cell value change.
Having circular reference Excel returns zero as result for such formulas. With applied date format for such cell it is correctly shown as Jan 00, 1900 (or 00.01.1900). No need to change regional setting for your OneDrive or SharePoint site (procedure is slightly different for them), if only for training purposes.
What could be done - add time stamp using iterative calculation technique in Excel Desktop. If open in Excel Online, after some confirmation, time stamp continue to work in Online version as well. I'm not sure how reliable such solution, will it work for different users, in co-authoring mode, after any file update, etc. If works that will be your risks.
Excel Online has no option to switch-on iterative calculations which are required for time stamp trick. VBA doesn't work on Excel Online and I'm not sure if Office Script could be triggered by cell value change.
Having circular reference Excel returns zero as result for such formulas. With applied date format for such cell it is correctly shown as Jan 00, 1900 (or 00.01.1900). No need to change regional setting for your OneDrive or SharePoint site (procedure is slightly different for them), if only for training purposes.
What could be done - add time stamp using iterative calculation technique in Excel Desktop. If open in Excel Online, after some confirmation, time stamp continue to work in Online version as well. I'm not sure how reliable such solution, will it work for different users, in co-authoring mode, after any file update, etc. If works that will be your risks.
thank you for your suggestion.
Creating the file first on desktop and then uploading it worked.
And I found a workaround for the Time difference as it is 9 hours which are 0,375 of a day I add that like this:
=IF(G8<>"",IF(E8="",NOW()+0,375,E8),"")
thanks again
Could you please explain how you got a static date/time stamp in excel online as I was trying to implement this in my organization?
First you enable timestamp through iterative calculations, as it is explained for example here https://superuser.com/questions/1592650/how-to-run-multimple-timestamps-in-an-excel-sheet/1592665#1592665, opening the file in Excel Desktop.
While done, you may open such file in Excel for web, formula continues to work.
useruser , you are welcome
