This article is contributed. See the original author and article here.
If you use workbooks or templates and do not want to keep clicking refresh, you can now set it to auto-refresh. Refresh frequency (interval) ranges from 5 mins to a day, just like Azure dashboard.
Here are three simple steps:
1. Open workbook and Auto refresh is available in toolbar (default set to off)
2. Click on Auto refresh, Choose the refresh frequency (interval) and click Apply. These intervals are same as Azure dashboard.
3. Views will be updated at this interval
Things to remember:
- Auto refresh is off by default. You need to explicitly set it
- Auto refresh works in ‘view’ mode and stops in ‘edit’ mode
- Auto refresh settings are not persisted (each time you open workbook you have to set it) #designedforoptimalperformance
Learn more here
Brought to you by Dr. Ware, Microsoft Office 365 Silver Partner, Charleston SC.
Recent Comments