Forum Discussion
Automatic Date Update (No Interaction)
We have a file I wish to have displayed on a TV 24/7 in which a counter shows how many days since an event last occurred. The only time interaction with the file would occur would be to update the la...
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:
- In Excel use menu option: Data > New Query > From other sources > Blank Query
- In PQ use menu option Advanced Editor and make this edit
let
Source = DateTime.LocalNow
in
Source - Click Done
- Click Invoke
- Click File > Close & Load
- In Excel click Table Tools Design > Properties
- Click small icon (connection properties) next to Name:
- Check Refresh Every and set to 1 minutes
- 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.
Worked perfectly. Thank you very much. I've never used Query before and you made it very easy to figure out.