📊 Lesson 6.1: Sharing, Comments & Co-authoring via OneDrive

Why the Cloud Changes Everything

For most of this course your workbook has been a single file that only you touched. That's fine for personal work, but the moment two people need to look at the same numbers, the old way of working falls apart fast. You email budget.xlsx to a colleague, they make changes and email it back as budget_v2.xlsx, someone else edits the original in the meantime, and within a day you have four versions and no idea which one is true. This is the "email attachment" trap, and almost everyone has been burned by it.

The fix is to stop passing copies around and instead keep one workbook in a shared place that everyone reaches. In the Microsoft world that place is OneDrive (your personal cloud storage) or SharePoint (the shared team storage that powers Microsoft Teams and company sites). When a workbook lives there, it isn't a file you send — it's a single living document with one address. People don't get copies; they get access to the same workbook. That one change is what unlocks real-time collaboration, sharing links, comments that stay attached to the data, and a full history of every version.

This is the honest heart of the lesson, so let's say it plainly up front: a workbook saved only on your own computer as a local .xlsx cannot be co-authored. Real-time collaboration is a cloud feature. If you're working in Excel for the web, your files already live on OneDrive, so you're set up for it automatically — this is one place the free web version shines. If you're in the desktop app, you must save (or move) the workbook to OneDrive or SharePoint first; a file sitting in your local Documents folder will not offer live co-authoring no matter how you try to share it.

The Share Button — Links vs Specific People

Once a workbook is on OneDrive or SharePoint, the Share button (top-right on the web, top-right of the ribbon area in the desktop app) is your control panel for who gets in and what they can do. It looks simple, but the choices inside it matter for both convenience and safety, so let's go through them carefully.

Two ways to share

When you click Share, you're really choosing between two models:

• Share with specific people. You type the email addresses of the exact people who should have access. Excel sends each of them an invitation, and only those accounts can open the workbook. This is the safest option and the one to prefer for anything even mildly private.
• Copy a link. You generate a shareable link and paste it wherever you like — a chat, an email, a document. Anyone the link is scoped to can open the workbook by clicking it. Convenient, but you must understand the link's scope, because a link can be forwarded.

Link settings — read these before you send

Before you copy a link, open its settings (a gear or "Link settings" option in the Share panel). The exact wording shifts over time and differs between a personal Microsoft account and a work/school account, but you're generally choosing among options like these:

Alongside the scope, you'll usually find a permission toggle and a few extra controls:

• Can edit vs Can view. Editors can change the workbook; viewers can only read it (and usually still add comments). Give view access unless someone genuinely needs to change the numbers — it's easy to grant more later.
• Expiration date. On some plans (typically work/school accounts) you can set a link to stop working after a chosen date — great for a link that only needs to live for a project.
• Password. On some plans you can require a password to open the link, adding a second gate for an "anyone with the link" share.
• Block download. On some plans a view link can prevent downloading a local copy, so the data stays in the cloud.

Managing and stopping sharing

Sharing isn't one-and-done. Reopen the Share panel (often via Manage Access) at any time to see who currently has access, change someone from editor to viewer, remove a person entirely, or stop sharing a link so that old URL no longer opens the workbook. Making a habit of reviewing access — especially after a project ends or someone leaves a team — is a core part of using shared workbooks responsibly. If you ever suspect a link has spread too far, the fix is simple: delete that link and issue a new one; the old URL immediately goes dead.

Co-authoring — Editing Together, Live

Co-authoring is the headline feature that shared cloud workbooks unlock: two, five, or a dozen people can have the same workbook open and edit it at the same time, each seeing the others' changes appear within seconds. There's no more "I'll take the file, you wait." Everyone works together in one place.

When people are co-authoring, Excel shows presence: little colored flags or name labels mark where each person's cursor or selection is, so you can see that Maria is working in the totals while Sam edits the raw data below. Changes flow both ways automatically — you don't press a "sync" button; type a value and your collaborators see it appear in their own view. It feels less like passing a file around and more like several people standing at the same whiteboard.

What co-authoring needs

Co-authoring works when a few conditions line up, and knowing them saves a lot of head-scratching:

• The workbook is stored on OneDrive or SharePoint — not a local drive (this is the big one).
• It's a modern .xlsx workbook (the old .xls format and some special features don't co-author).
• Everyone opens it in a version that supports co-authoring — Excel for the web always does, and current desktop and mobile apps do too when signed in.
• People are online — co-authoring is a live, connected experience.

How this compares to Google Sheets

If you've used Google Sheets, live co-authoring will feel familiar — and there's honest history worth knowing. Google Sheets was cloud-native from day one: it was built in the browser, for the browser, with real-time multi-person editing as its founding idea. That head start is why Sheets earned a reputation as the effortless choice for collaboration. Excel came from the opposite direction — it began as a powerful desktop application decades ago and matured into cloud collaboration over many years, adding Excel for the web, co-authoring, and OneDrive integration on top of an enormously capable engine.

The practical result today is that both do live collaboration well. Sheets still feels a touch more seamless for pure, casual cloud sharing because that's its native soil. Excel gives you that same real-time editing plus the deepest analysis toolset in the spreadsheet world and a first-class offline desktop app. Neither is "the winner" — the honest read is that Sheets started in the cloud and Excel grew into it, and if collaboration is all you need, both are excellent.

⚠️ Important Note: Co-authoring is genuinely reliable, but two people typing into the exact same cell at the same instant is still worth avoiding — Excel will reconcile it, but a quick "you take the top section, I'll take the bottom" chat prevents surprises. And if you're editing with an unstable connection, expect the occasional pause while changes catch up.

Comments vs Notes, and @mentions

Collaboration isn't only about editing the numbers — it's about talking about them right where they live. Excel gives you two related-but-different tools for annotating cells, and choosing the right one matters.

Modern threaded Comments

A Comment in modern Excel is a threaded conversation attached to a cell. You select a cell, add a comment ("Should this include tax?"), and a collaborator can Reply right underneath — building a little back-and-forth thread pinned to that exact cell. When the discussion is settled, anyone can mark the thread Resolved, which tucks it away without deleting the history. This is the tool for discussion: questions, feedback, and decisions that involve other people.

Classic Notes

A Note (called a "Comment" in much older versions of Excel, which is a genuine source of confusion) is a simple, non-threaded sticky-note annotation attached to a cell. It's just your text — there's no reply, no resolve, no conversation. Notes are perfect for a standalone reminder or label: "figures are in thousands" or "confirmed by finance." Think of a Note as a Post-it and a Comment as a chat thread.

@mentions — pull the right person in

Inside a threaded comment you can type @ followed by a name (an @mention) to tag a specific collaborator. Excel notifies that person — typically by email, with a link straight to the comment — so they don't have to be watching the workbook to know you need them. It's the difference between "I hope someone sees this" and "Sam, I need your eyes on cell D14." On work/school accounts, mentioned people can often reply straight from the email notification. @mentions are one of the most useful collaboration habits you can build: when a comment needs an answer from a particular person, mention them by name.

Version History — Your Time Machine

Shared editing raises an obvious worry: what if a collaborator overwrites something important, or a formula gets mangled? Because your workbook lives in the cloud, Excel keeps an automatic Version History — a running timeline of past versions you can look back at and, when needed, roll back to. It's the safety net that makes co-authoring comfortable.

You'll typically reach it through File > Info > Version History (in the desktop app), or by clicking the file name / title bar at the top and choosing Version History in Excel for the web. A panel opens listing earlier versions with timestamps and, often, who made the changes. From there you can:

• Open a previous version to inspect it — it opens as a read-only view so you can see how the workbook looked at that moment without disturbing the current one.
• Compare what changed between then and now, to find where something went wrong.
• Restore a chosen version, which brings the workbook back to that earlier state (and, reassuringly, the current state is itself saved as a version first, so restoring is never a one-way door).

This is worlds better than the old habit of saving budget_final_v3_REALLYfinal.xlsx copies "just in case." The cloud does that for you, automatically and quietly, so you can experiment freely knowing yesterday's version is one click away. It pairs naturally with everyday Ctrl+Z undo: undo handles the "oops I just did that," and Version History handles "wait, what did this look like on Tuesday?"

⚠️ Important Note: Version History depends on the file living in OneDrive or SharePoint — it's another cloud benefit. A workbook saved only on your local drive relies on your own backups and manual saved copies. How far back the history reaches and how versions are pruned can vary by plan, so treat Version History as a strong safety net rather than a permanent archive.

Sharing Safely — Best Practices

✅ Do's

• Prefer "specific people" over "anyone with the link." Name who gets in; it's the safest default and survives forwarding.
• Give "view" unless "edit" is truly needed. It's easy to upgrade someone to editor later; harder to undo damage.
• Use threaded Comments with @mentions for anything that needs a person's attention or a reply.
• Review "Manage Access" periodically — remove people and links you no longer need, especially after a project ends.

❌ Don'ts

• Don't email copies of a shared workbook. That recreates the version-chaos the cloud exists to prevent — send the link instead.
• Don't paste an "anyone with the link" URL into a public place unless the data is genuinely meant to be public. Treat that link like a password.
• Don't expect co-authoring on a local file. Save it to OneDrive or SharePoint first, always.
• Don't assume expiry/password options exist on every plan — check your own Share panel rather than promising a colleague a feature you may not have.

🎯 Project: Share Your Tracker

Time to make your tracker a shared, collaborative workbook. You'll move it to OneDrive (if it isn't there already), share it with someone as a viewer using the safe specific-people option, and add a threaded comment with an @mention — the exact workflow you'd use at work. If you don't have a real collaborator handy, use a second email address of your own (even a free one) as your "reviewer" so you can see the whole flow end to end.

Cell selected: the "Total" cell (e.g. B12)

Comment text:
@Reviewer Name  Does this total need to include the
service fee in row 9, or is that tracked separately?
Want to confirm before I share this more widely.

- Use a threaded Comment (has Reply/Resolve), NOT a Note.
- Type @ then start typing the name to trigger the mention.
- Keep permission at "Can view" for this project.

📓 Learning Journal

📝 Lesson Summary

🎉 What You've Accomplished

You've turned a solo workbook into a genuinely collaborative one. You know why the cloud is the prerequisite, how to share safely with the right permissions, how live co-authoring works and where it came from, how to hold a conversation right on a cell, and how to rewind to an earlier version if something goes sideways. That's the complete toolkit for working with people in Excel — a skill every workplace values.

❓ Common Questions

🔭 Looking Ahead

In the next lesson — Lesson 6.2: Import/Export & a Taste of Power Query — we shift from sharing your data to getting data in and out. You'll import CSV and text files, export to CSV and PDF, learn the real pitfalls of CSV (types, dates, encoding), and get a conceptual first taste of Power Query — Excel's repeatable, refreshable data-cleanup engine.

✅ Before the Next Lesson

• Confirm your tracker is saved on OneDrive and shared with at least one viewer
• Practice adding, replying to, and resolving one threaded comment
• Write your Learning Journal entry for this lesson

📚 Additional Resources

• Collaborate on Excel workbooks with co-authoring (Microsoft Support)
• Share files and folders — Microsoft Support
• OneDrive — cloud storage overview