Automatic Date Update (No Interaction)

ldcox8551 

Any data source can be set to auto-refresh and almost all data sources have a system time function that can be returned to Excel using MS Query or PowerQuery. Here is the PQ example:

1.  In Excel use menu option: Data > New Query > From other sources > Blank Query
2.  In PQ use menu option Advanced Editor and make this edit
   let
   Source = DateTime.LocalNow
   in
   Source
3. Click Done
4. Click Invoke
5. Click File > Close & Load
6. In Excel click Table Tools Design > Properties
7. Click small icon (connection properties) next to Name:
8. Check Refresh Every and set to 1 minutes
9. Click OK twice to close properties

You now will have the current date updated every minute automatically. You can add formulas to calculate time elapsed from the "Invoked Function" table.