mirror of
https://github.com/hanzoskill/excel-weekly-dashboard.git
synced 2026-10-30 21:10:48 +00:00
527 B
527 B
Weekly Refresh Checklist (Excel + Power Query)
- Drop the new week’s files into the source folder (do not rename unless specified).
- Open the workbook.
- Data ➜ Refresh All.
- Check Refresh Status sheet:
- Row counts match expectations
- No query errors
- Latest ISO week exists
- Review Exceptions pivot (if present) and resolve or log issues.
- Save as
KPI_Weekly_YYYY-WW.xlsx(ISO week), then archive.
If any query shows errors, stop and investigate; do not export/publish partial results.