How to judge whether a spreadsheet is ready to replace
A spreadsheet may contain workflow rules and approval history that are easy to overlook.
What to do
- List who maintains it, who receives its exports, and what other tools use the information.
- Review a few real rows with staff to identify formulas, manual overrides and exceptions that must be supported.
- Try the replacement with a controlled sample and verify outputs with each person who receives them before retiring the old file.
Reference: Microsoft guide to preparing for modernization.
Related MyNew service: Digital Transformation.