SPREADSHEET DEPENDENCY / SOLUTION GUIDE

Keep essential spreadsheets useful without making them invisible systems.

A pragmatic route for teams whose critical reports, registers and approvals still travel through Excel and shared drives.

An engraved catalogue, source layers and magnifier; a metaphor for knowing what information exists.
CONCEPTUAL ENGRAVING / DATAGOVERNANCE.CA

Practical information and fictional examples for scoping, not claims of client work, measured results, independent assurance or certification.

Find the spreadsheet that actually matters

A spreadsheet is not a problem simply because it is a spreadsheet. The risk rises when a critical decision depends on an undocumented workbook with uncertain ownership, uncontrolled copies or unclear inputs. Identify a small set of decision-critical files, their business purposes and the people responsible for interpreting and updating them. Do not start with an inventory of every file ever created.

Map inputs, transformations and decisions

Trace one workbook from incoming source to calculation, output, approval and recipient. Capture where formulas are manually overridden, which versions are authoritative and how changes are communicated. A document library can show last modified dates without proving which version the board or finance team used. Keep a simple record of the approved reporting period and the person who confirmed it.

Apply lightweight controls at the handoff

Useful controls can be modest: protected formula ranges where appropriate, a maintained definition tab, version and owner metadata, an exception log, second-person review of material changes, and a standard archive location. Treat permissions, backup and retention as separate decisions requiring internal authority. Do not promise that protecting a worksheet provides security or that an automated export is an audit trail.

Know when migration is actually justified

After a few operating cycles, reassess volume, collaboration, error consequences and time spent reconciling. A database or workflow platform may be worthwhile, but only against a defined business case and an owner who will maintain it. Document what a move would change: source-of-truth decisions, access, versioning, validation and handoffs. A spreadsheet-to-SaaS migration that recreates the same unclear definitions has not solved governance.

QUESTIONS BEFORE DECIDING

What buyers usually ask

Will you remove Excel?

No automatic replacement is assumed. The first objective is a reliable process around what the team uses.

Is a shared drive enough?

It can help with collaboration but does not, by itself, settle definitions, ownership or approvals.

Do we need access to real customer data?

Not for a first conversation; use metadata and fabricated or approved redacted examples.

NEXT PRACTICAL STEP

Start with one decision, not a platform purchase.

We can discuss a scoped engagement using the context above. Do not send confidential information through an initial inquiry.

READ NEXT