Embedded Files
- Spreadsheet performance can be impacted by volatile functions [NOW(), TODAY(), RAND(), RANDBETWEEN()] - See this LINK for details
- Change File > Spreadsheet Settings > Calculation > Recalculation to "On Change and Every Hour" update the dashboard automatically
- To speed up a sheet, it's a good practice to make a calculation like NOW() in it's own cell and then use the value of that cell in other calculations instead of performing the calculation in multiple formulas throughout the sheet.
Page updated
Google Sites
Report abuse