November 15, 2026
How to lock a closed period in Excel, and why sheet protection isn't enough
You lock a closed period properly by freezing its data outside the workbook and recording every change attempted after close. Excel's Protect Sheet does neither — here's what a real period lock looks like for a month-end consolidation.
You lock a closed period properly by taking the closed figures out of the workbook’s control: they are frozen in a central store, any later change is either blocked or recorded as a new entry with who, what and when, and a reviewer can prove nothing moved. Excel’s Protect Sheet does none of this — it stops casual typing in locked cells, but it keeps no record of who removed the protection or what they changed after.
That gap matters more than it looks, because for many finance teams the closed month still lives in a spreadsheet.
How most teams “lock” a closed month today
The usual routine looks like this. The consolidation workbook for October is finished, reviewed and reported. Someone selects the October tab, clicks Review → Protect Sheet, sets a password, and saves the file to the shared drive. The month is now “closed”.
Microsoft is direct about what this does and doesn’t do. Its own support page for the feature says that “worksheet level protection isn’t intended as a security feature” and that “it simply prevents users from modifying locked cells within the worksheet” (Microsoft Support, “Protect a worksheet”, accessed 2026-10-28). It is a guard against accidental typing, not a control.
Here is what Protect Sheet leaves open:
- Anyone with the password can undo it. Passwords for shared close files tend to be shared too — with the controller, a backup, sometimes a whole team.
- Nothing records the unprotection. If someone unprotects the October tab in December, changes an accrual and protects it again, the workbook looks exactly as it did before, just with a different number.
- The file itself can be replaced. A copy saved over the original, or an older version restored from an email attachment, carries its own protection and its own figures.
- Linked figures can still move. If the closed tab pulls values from another sheet or another workbook that isn’t protected, the “locked” totals can change without anyone touching the locked cells.
None of this requires bad intent. A late invoice, a reclassification requested by an auditor, or a well-meant fix to a formula can all change a closed month. The problem is that afterwards nobody can show what changed, when, or why.
Why this is still a live problem
It would be easy to assume that month-end close moved out of spreadsheets years ago. Recent figures suggest otherwise. Research published by Sixthfin, a company focused on risk detection and process optimisation for finance, controlling and audit teams, and carried out by Odoxa among 303 CFOs at private UK companies with 250 or more employees, found that 67% still use Excel for account analysis and reconciliation, 57% use spreadsheets for accruals, 54% for manual journal entries, and 53% for managing the close calendar (IT Brief UK, “UK CFOs still rely on spreadsheets for financial close”, 18 May 2026). The research comes from a company working in this market, so treat it as directional rather than definitive — but the pattern will be familiar to most controllers.
Auditors look closely at exactly these steps. KPMG’s study of material weaknesses reported in FY’25 SEC filings, based on Audit Analytics data, found that the most frequently cited financial close and reporting issue was a “lack of precision, timeliness, and adequate oversight of management review controls”. The same study also cites weaknesses in the review of journal entries, in account reconciliations and in the documentation of information produced by the entity (KPMG LLP, “Trends in material weaknesses”). A management review is only as strong as the reviewer’s ability to show that the numbers they reviewed are the numbers that were reported, and that they stayed that way.
What “closed” has to mean
A useful test: could a reviewer, six months from now, prove that the October figures on record are the same figures that were approved at close, and list every change made since? If the honest answer is “we’d compare file versions and hope”, the period isn’t locked. It’s protected from typing.
A closed period that stands up to that test has three properties.
The data is frozen outside the workbook
The approved figures for October live in a central database, not only in the cells of one file. The spreadsheet reads them and displays them, but cannot overwrite them. Copying the workbook, restoring an older version, or emailing it around doesn’t change what’s on record, because the record isn’t the file.
Changes after close are blocked or recorded — never silent
Once October is closed, the fields behind it reject new values by default. When a genuine correction is needed, it goes in as a new, visible entry: the original value stays, the adjustment sits next to it, and the change carries an author, a timestamp and, ideally, a reason. That is the difference between a correction and an edit. Auditors are comfortable with the first; they are rightly uneasy about the second.
A reviewer can prove nothing moved
The reviewer doesn’t have to trust the file. They can see the closed values, the full change history for the period, and who approved the close. “Has anything changed since we signed off?” becomes a question with a direct answer instead of a reconciliation exercise.
A worked example: one month-end consolidation
Take a group consolidation built in Excel. Twelve subsidiaries each fill in a reporting template — revenue, costs, intercompany balances, accruals — and send it to group controlling, where one workbook pulls the templates together into the group pack.
With sheet protection. Group controlling protects each subsidiary tab once the pack is reported. In week two of the next month, a subsidiary finance lead emails a corrected template because an accrual was booked to the wrong cost centre. The group controller unprotects the tab, pastes in the new figures, and protects it again. The group pack now differs from what was presented to management, and the only evidence is an email thread. If the auditor later asks why intercompany balances don’t match the reported pack, the team reconstructs the story from inboxes.
With a governed period lock. The subsidiaries fill in the same templates, in the same Excel, but their entries are validated as they are typed and written to a central database. When group controlling closes October, the fields for October lock on the server. The subsidiary’s corrected accrual can’t overwrite the closed figure; it goes in as a recorded adjustment, visible to group controlling, with who made it and when. The reported pack is still the reported pack. The adjustment is still visible. The auditor sees both.
Nobody had to learn a new tool or rebuild the consolidation model. The change is where the closed figures live and what happens when someone tries to change them.
What this looks like with IT-TIDY
IT-TIDY is a governance layer behind the spreadsheets finance teams already use. A lightweight Excel add-in connects the existing workbook to a central database: values are validated as they are typed, every change is recorded with who, what and when, consolidations run on the server, and closed periods stay locked. A correction after close is a new, recorded change, not a silent edit. The Finance & Controlling page covers the budget, forecast and consolidation processes this typically applies to, and how IT-TIDY works explains the add-in and the database behind it.
A related result, from a different part of the same problem: in a group with around 100 foreign subsidiaries, running cross-border procurement planning through an add-in with blocking entry controls, data correct at first submission went from 39% to 97% and central corrections fell by 85%, measured using a Lean Six Sigma (DMAIC) method on a certified path. That project measured validation at the point of entry, not period locking — but it points at the same idea. When data is controlled where it is entered and stored centrally, fewer corrections are needed after the fact, and the ones that are needed are visible.
Period locking is one of four pieces that tend to be missing together. If you want the wider picture — validation at entry, a recorded change history, controlled periods and measured reliability — see what spreadsheet governance actually means.
Where to start
Pick the one close process where a silent post-close change would hurt most — usually the group consolidation or the management reporting pack — and ask the six-month test: could you prove today that last quarter’s figures haven’t moved? If not, the spreadsheet risk check-up is the quickest way to see where your close is exposed, and a 30-day pilot on that one process, with one team, is enough to run a full month-end with the period genuinely locked and compare it with the month before.