MO-211: Manage Workbook Options and Settings
This is the lightest domain on MO-211 at 10-15% of the exam, but it is where the exam checks whether you can be trusted with a workbook other people depend on: enabling and copying macros safely, protecting worksheets and structure, referencing external workbooks, and controlling how formulas recalculate. Small domain, real consequences if you get it wrong on a shared file.
Checked against Microsoft’s own published pages on September 16, 2026.
The numbers
Manage workbooks: macros, external references, and versions
This skill group is where MO-211 first assumes you are comfortable with macro-enabled files. You are expected to enable macros in a workbook that Excel has flagged (the yellow security banner), copy a macro from one open workbook into another via the Visual Basic editor's Project Explorer, and reference cells or ranges in a different open workbook from a formula.
Enabling macros matters beyond the exam too: Excel disables macros by default in files from an untrusted source, and a macro-driven task in a workbook that never got macros enabled will simply not run — the check will see no evidence the macro fired. Confirm the security banner is cleared before you rely on anything VBA-based later in the same project.
"Manage workbook versions" is the other skill in this group — knowing how to view and restore previous saved versions of a workbook, which in most modern Excel setups means AutoSave / version history rather than manual backup files.
Prepare workbooks for collaboration: protection and calculation settings
Restrict Editing, Protect Sheet, and Protect Workbook Structure are three distinct commands that get confused constantly. Restrict Editing controls who can edit a document and how. Protect Sheet locks cells on one worksheet (and can allow specific exceptions, like letting users still sort or use AutoFilter). Protect Workbook Structure stops someone from adding, deleting, renaming, or reordering sheets, without touching what's editable inside any single sheet.
A task that says "prevent the structure of this workbook from being changed" is asking for Protect Workbook Structure specifically — applying Protect Sheet instead locks the wrong thing and the check will not see the structure protection it was looking for.
Configure formula calculation options is the other half of this group: switching between Automatic and Manual calculation, and knowing that Manual mode means formulas will show stale values until you recalculate (F9) — a real trap if a later task in the same project checks a calculated value that never recalculated because the workbook was left in Manual mode from an earlier task.
Restrict Editing is not the same command as Protect Sheet, and the exam treats them separately
Restrict Editing (under Review, or File > Info > Protect Workbook > Restrict Editing depending on version) is a broader, document-level control: it can limit what kind of changes are allowed at all — formatting, comments only, filling in a form, or no changes — and can be scoped to specific people or ranges, optionally behind a password. It answers a different question than Protect Sheet does: Protect Sheet asks "which cells on this one sheet can be edited," while Restrict Editing asks "what categories of change is anyone allowed to make to this document."
A task instruction that talks about limiting the TYPE of edit allowed — read-only, comments-only, form-filling-only — is describing Restrict Editing, not Protect Sheet. Applying the wrong one of the three protection commands (Restrict Editing, Protect Sheet, Protect Workbook Structure) is a check that reads as unattempted even though you did protect something, just not the thing being asked about.
The practical habit worth building: before applying any protection command, identify which of the three questions the task is actually asking — what kind of edit, which cells, or which sheets — and pick the one command that answers that specific question.
What costs people points
These two commands are easy to conflate because both live under the Review tab's Protect group. Protect Sheet is about cells and content on one sheet; Protect Workbook Structure is about the tabs themselves. Read the instruction for whether it is describing editing individual cells or rearranging/adding/deleting sheets.
If an earlier task in the project switched calculation to Manual and you never switched it back, every formula you build afterward shows a value that may be stale until you press F9 or switch back to Automatic. A grader reading the workbook's saved state will see whatever value was last calculated, not what the formula would currently produce.
A macro recorded in one workbook often refers to specific sheet names or cell addresses. Copy it into a different workbook via the VBA editor and it can silently run against the wrong sheet, or error out, if the target workbook's structure doesn't match what the macro expects.
"Limit what kind of changes are allowed" (read-only, comments-only, form-filling) is a Restrict Editing task, not a Protect Sheet one. Protect Sheet locks specific cells on one sheet; it does not express document-wide edit-type restrictions the way Restrict Editing does. Applying the wrong one leaves the actual instruction unmet even though a protection command was used.
Related questions
Is this the hardest domain on MO-211?
No — at 10-15% it is the lightest domain by weight, but the individual skills (protection commands, macro handling, calculation modes) are each easy to mix up, so accuracy matters more than raw study time here.
What is the difference between Restrict Editing and Protect Sheet?
Restrict Editing is document-wide and controls what CATEGORY of change is allowed — read-only, comments only, form-filling only — optionally scoped to specific people or ranges. Protect Sheet locks specific cells on one worksheet. They answer different questions and are not interchangeable.
Do I need to write VBA code for this domain?
No. This domain is about enabling, copying, and managing macros that already exist, plus workbook protection and calculation settings. Recording, naming, and editing simple macros is tested separately under Create Advanced Formulas and Macros.
What is the difference between Protect Sheet and Protect Workbook Structure?
Protect Sheet locks cell content and editing on one worksheet. Protect Workbook Structure stops sheets themselves from being added, deleted, renamed, hidden, or reordered. They are independent — protecting one does not protect the other.
Why would a formula show the wrong value even though it looks correct?
If calculation mode is set to Manual, formulas display whatever they last calculated rather than updating live. Press F9 to force a recalculation, or switch calculation back to Automatic, before you finish a task that depends on a formula's current value.
Sources
Read on September 16, 2026. Where this page says something is not published, that means we looked and did not find it — check for yourself.
Keep reading
Find out what you would actually score
Take a full, timed MO-211 practice exam, upload the workbook you built, and get a score out of 1000 with a per-task breakdown of where the points went. Your first one is free.
No credit card needed.