How to Share a Workbook in Excel: Complete Step-by-Step Guide for Real-Time Collaboration
Learn how to share a workbook in Excel using OneDrive, SharePoint, and legacy methods. Complete guide with permissions, co-authoring, and troubleshooting.

Learning how to share a workbook in Excel has become one of the most essential skills for anyone working in a team environment, whether you are tracking budgets with colleagues, building reports with remote analysts, or simply collaborating on a shared dataset. Microsoft has dramatically improved its collaboration tools over the past few years, replacing the clunky legacy Shared Workbook feature with modern real-time co-authoring through OneDrive and SharePoint. This guide walks you through every method available in 2026. Practice with the free Excel practice test on PracticeTestGeeks (500+ questions with answer explanations).
Excel collaboration today supports simultaneous editing by dozens of users, automatic version history, granular permission controls, and seamless integration with Microsoft Teams. Before cloud-based co-authoring existed, sharing a workbook meant emailing copies back and forth, manually merging changes, and praying nobody overwrote your formulas. Today, two people can edit the same cell within seconds of each other and Excel resolves the conflict gracefully behind the scenes. The difference in productivity is enormous, especially for distributed teams.
The most popular keyword searches around Excel collaboration include questions about how to merge cells in Excel without losing data during sharing, how to freeze a row in Excel so remote collaborators always see headers, and how to create a drop down list in Excel that everyone on the team must follow. Sharing a workbook is rarely just about granting access โ it is about preserving structure, validating input, and protecting formulas while still letting teammates contribute. We cover all of these dimensions in this article.
This guide is written for US-based professionals using Excel for Microsoft 365, Excel 2021, Excel 2019, and Excel for the web. Each version has slightly different sharing options, and we call out the differences as we go. If you are using an older standalone version like Excel 2016 or earlier, you can still use the legacy Shared Workbook feature, though Microsoft has officially deprecated it in favor of co-authoring. The legacy feature lacks support for many modern functions like dynamic arrays, XLOOKUP, and the modern vlookup excel improvements.
We will also touch on common pitfalls: accidentally sharing with edit permissions when you meant view-only, sending links to personal email addresses outside your organization, and forgetting to remove access after a project ends. Permission hygiene matters more than ever now that workbooks routinely contain sensitive financial data, customer PII, or proprietary formulas. A single misconfigured share link has caused major data breaches at Fortune 500 companies, so treat every share action as a security decision.
By the end of this article you will know exactly how to share a workbook in Excel using modern co-authoring, how to fall back on the legacy method when needed, how to set permissions correctly, how to track who changed what, and how to troubleshoot the most common errors. You will also pick up a set of best practices that experienced Excel power users follow when collaborating with finance teams, project managers, and executives.
Let's start by understanding the core sharing methods available, then walk through each one step by step with screenshots and exact menu paths. Keep this guide bookmarked โ you will return to it whenever you onboard a new teammate or set up a new shared project.
Microsoft Excel: upcoming dates and official changes
- Jun 30, 2026: Certiport retired the Microsoft Office Specialist 2016 certifications, including MOS Excel 2016, on June 30, 2026. The Microsoft 365 Apps and Office 2019 Excel exams are still available. (certiport.pearsonvue.com)
- Updated Oct 16, 2026: Delivery is now Proctored live-in-the-application exam via Certiport Authorized Testing Centers (in-center or remote-proctored) (previously Proctored live-in-the-application exam via Certiport Authorized Testing Centers).
- Updated Oct 16, 2026: Eligibility is now No formal prerequisites; about 150 hours of instruction and hands-on experience recommended (previously No formal prerequisites; ~150 hours of instruction and hands-on experience recommended (Associate)).
- Updated Oct 16, 2026: Time limit is now 50 minutes (60 minutes seat time) (previously 50 minutes (60 minutes seat time)).
Facts verified Oct 17, 2026 against Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business. Dates that have passed are removed automatically.
- The MOS Excel (Microsoft 365 Apps) exam has 33 to 37 questions. (certiport.pearsonvue.com)
- The MOS Excel Expert (Microsoft 365 Apps) exam has 23 to 27 questions. (certiport.pearsonvue.com)
- Microsoft Office Specialist Excel exams last 50 minutes, with 60 minutes of total seat time. (Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business)
- The passing score for Microsoft Office Specialist Excel exams is always 700 on Certiport's 1 to 1000 scaled score. (certiport.pearsonvue.com)
- After failing a Microsoft Office Specialist Excel exam, candidates must wait 24 hours before the first retake and 48 hours before each later retake, and there is no annual limit on attempts. (Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business)
- Microsoft Office Specialist Excel certifications earned on or after September 23, 2025 are valid for five years; those earned earlier do not expire. (certiport.pearsonvue.com)
- The Microsoft Office Specialist Excel exam is proctored and delivered live in the Excel application through Certiport Authorized Testing Centers, either in person or remote-proctored. (Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business)
- Microsoft recommends that candidates for the MOS Excel Associate (Microsoft 365 Apps) certification have about 150 hours of instruction and hands-on experience with Excel. (Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business)
- Candidates get their MOS Excel score report as soon as they finish the exam, and it can also be viewed in their Certiport profile. (certiport.pearsonvue.com)
Facts verified Oct 17, 2026 against Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business. Dates that have passed are removed automatically.
Microsoft Excel Exam at a Glance
| Item | Detail | Official source |
|---|---|---|
| Number of questions (Excel Associate (MO-210)) | 33-37 questions | certiport.pearsonvue.com |
| Number of questions (Excel Expert (MO-211)) | 23-27 questions | certiport.pearsonvue.com |
| Time limit | 50 minutes (60 minutes seat time) | Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business |
| Passing score | 700 on a 1โ1000 scale | certiport.pearsonvue.com |
| Retake policy | Wait 24h after 1st fail, 48h before each later retake; no annual limit | Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business |
| Validity | Valid 5 years (earned on/after Sept 23, 2025) | certiport.pearsonvue.com |
| Delivery | Proctored live-in-the-application exam via Certiport Authorized Testing Centers (in-center or remote-proctored) | Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business |
| Eligibility | No formal prerequisites; about 150 hours of instruction and hands-on experience recommended | Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business |
| Score release | Score report at end of exam; also in Certiport profile | certiport.pearsonvue.com |
Facts verified Oct 17, 2026 against Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business. Dates that have passed are removed automatically.
Free Excel Study Tools
Interactive Excel resources on PracticeTestGeeks, free to start:
- Free Excel Questions and Answers โ 16 questions with instant scoring and answer explanations
- Excel flashcards โ review key terms and concepts card by card
- Excel study guide โ topic-by-topic overview of what the exam covers
- Excel cheat sheet โ one-page printable summary for last-minute review
Excel Sharing by the Numbers

The Five Ways to Share an Excel Workbook
OneDrive Share Button
SharePoint Document Library
Microsoft Teams Channel
Email Attachment
Legacy Shared Workbook
The OneDrive method is by far the most common way to share a workbook in Excel today, and it works almost identically across Windows, Mac, and Excel for the web. It is also the foundation for anyone asking how to collaborate in Excel online, because the browser version reads the same cloud copy. To start, open your workbook in Excel and click the Share button in the upper-right corner of the ribbon. If the file is not yet saved to OneDrive, Excel will prompt you to upload it first. Choose your OneDrive account or a SharePoint site, give the file a clear name, and click Upload. This single step converts your local workbook into a cloud-based collaborative document.
Once uploaded, the Share dialog presents you with several options. You can type email addresses of specific people, set their permission level to Can Edit or Can View, optionally require a sign-in, set an expiration date, and add a message. For external collaborators outside your organization, you may need to check the box that says Allow editing and explicitly grant guest access. Microsoft 365 administrators can restrict these external sharing options at the tenant level, so check with your IT team if the option appears greyed out.
SharePoint sharing follows the same logic but adds enterprise governance layers. Navigate to your SharePoint site, open the document library, upload the workbook, and either share it from the file menu or rely on inherited library permissions. SharePoint allows you to define site-wide groups like Site Members and Site Owners, making it easy to onboard new team members without manually adjusting every workbook. Power users often build dedicated SharePoint sites for entire departments such as Finance, Operations, or HR.
If your team uses Microsoft Teams, sharing becomes even simpler. Open a channel, click the Files tab, and either upload an existing workbook or create a new one directly from the New menu. Anyone with access to the channel automatically inherits edit permissions on that file. Teams also lets you pin important workbooks as tabs at the top of the channel, giving them prime visibility for the entire group. This is particularly useful for project trackers, sprint plans, and shared budgets.
For situations where cloud sharing is not an option โ perhaps you are sending a snapshot to an auditor, regulator, or external vendor โ email attachments remain a valid choice. From Excel, go to File then Share then Email and choose Send as Attachment. Excel attaches the current state of the workbook to a new Outlook message. Remember that the recipient receives a static copy; any edits they make will not flow back to your original. Always communicate clearly which version is canonical.
When you need backward compatibility with users running Excel 2016 or earlier on networked drives, the legacy Shared Workbook feature still exists. You will need to add it to the ribbon manually by going to File then Options then Customize Ribbon and enabling the Share Workbook (Legacy) command. We strongly recommend avoiding this path unless absolutely necessary, because it disables many modern features including tables, conditional formatting, and several functions that power users rely on every day.
Whichever method you choose, double-check the destination before clicking Send. The most common sharing mistake is accidentally posting a sensitive workbook to a public Teams channel or sending a link with edit permissions to an entire distribution list. Take a breath, verify the recipients, and confirm the permission level matches your intent.
If you want more targeted practice, the microsoft excel free download page covers the same material with additional questions and explanations.

Microsoft Excel Practice Test Questions
Prepare for the Microsoft Excel exam with our free practice test modules. Each quiz covers key topics to help you pass on your first try.
Microsoft Excel Excel Basic and Advance
Microsoft Excel Exam Questions covering Excel Basic and Advance. Master Microsoft Excel Test concepts for certification prep.
Microsoft Excel Excel Formulas
Free Microsoft Excel Practice Test featuring Excel Formulas. Improve your Microsoft Excel Exam score with mock test prep.
Microsoft Excel Excel Functions
Microsoft Excel Mock Exam on Excel Functions. Microsoft Excel Study Guide questions to pass on your first try.
Microsoft Excel Excel MCQ
Microsoft Excel Test Prep for Excel MCQ. Practice Microsoft Excel Quiz questions and boost your score.
Microsoft Excel Excel
Microsoft Excel Questions and Answers on Excel. Free Microsoft Excel practice for exam readiness.
Microsoft Excel Excel Trivia
Microsoft Excel Mock Test covering Excel Trivia. Online Microsoft Excel Test practice with instant feedback.
Setting Permissions Like a Pro for VLOOKUP Excel Workbooks
View Only permission lets recipients open, read, and download the workbook but blocks them from making any changes. This is ideal for executive dashboards, finalized reports, or any workbook where the formulas should not be altered. To set View Only access, click Share in the top-right of Excel, then change the dropdown from Can Edit to Can View before sending the link.
View Only is also the safest default when sharing with external partners. They can still copy values into their own files, but your master workbook remains pristine. Combine View Only with the Block Download option for maximum security โ recipients will be able to see the data in their browser but cannot save a local copy. This protects sensitive customer lists, pricing models, and proprietary VLOOKUP excel reference tables.
Cloud Co-Authoring vs Legacy Shared Workbook
- +Real-time editing by up to 100+ simultaneous users
- +Automatic version history with 500 versions saved
- +Works on desktop, web, mobile, and inside Microsoft Teams
- +Full support for modern features like dynamic arrays and XLOOKUP
- +Granular permission controls including expiration dates
- +Built-in chat and comments thread tied to specific cells
- +AES-256 encryption at rest and TLS in transit
- โRequires Microsoft 365 subscription for full features
- โInternet connection needed for real-time sync
- โExternal sharing may be blocked by IT administrators
- โSync conflicts possible during simultaneous identical cell edits
- โVBA macros and some legacy add-ins may not work in browser
- โLarge workbooks over 100 MB sync slowly on weak connections
Pros and Cons at a Glance
| Pros | Cons |
|---|---|
| Works on desktop, web, mobile, and inside Microsoft Teams | Internet connection needed for real-time sync |
| Full support for modern features like dynamic arrays and XLOOKUP | External sharing may be blocked by IT administrators |
| Granular permission controls including expiration dates | Sync conflicts possible during simultaneous identical cell edits |
| Built-in chat and comments thread tied to specific cells | VBA macros and some legacy add-ins may not work in browser |

Pre-Share Checklist Before Sharing a Workbook in Excel
- โSave the workbook to OneDrive or SharePoint before clicking Share
- โRemove any personal data, hidden sheets, or draft comments that should not be visible
- โVerify all formulas reference structured tables rather than hardcoded ranges
- โProtect critical cells and formulas using Format Cells then Protection
- โSet worksheet-level passwords on sheets you do not want edited
- โChoose the correct permission level: View Only, Can Edit, or Specific People
- โAdd an expiration date on the share link for time-bound projects
- โBlock download for highly sensitive workbooks containing PII
- โInclude a clear message explaining what recipients should do with the file
- โNotify recipients separately by email or chat so they actually see the share notification
Enable AutoSave Before You Share
Toggle AutoSave to On in the top-left corner of Excel before sharing any workbook. AutoSave only activates for files stored on OneDrive or SharePoint, and it ensures every edit by every collaborator is captured instantly. Without AutoSave, co-authoring still works but changes only persist when someone manually clicks Save, which defeats the purpose of real-time collaboration.
Co-authoring is the headline feature of modern Microsoft Excel sharing, and once you experience it you will never go back to emailing copies. When multiple users open a shared workbook simultaneously, each person sees a small colored flag with the others' initials hovering near the cell they are currently editing. Edits appear within roughly two seconds, formulas recalculate automatically, and Excel handles conflict resolution behind the scenes. For anyone who learned MS Excel on the old desktop-only model, the experience feels remarkably similar to Google Sheets but with the full power of Excel formulas underneath.
Version history is the safety net that makes co-authoring trustworthy. Excel automatically captures snapshots of your workbook every time someone makes a meaningful change, and it keeps up to 500 versions on OneDrive or SharePoint. To access version history, click File then Info then Version History, or right-click the file in OneDrive and choose Version History. You can preview any past version, compare it to the current state, restore it as the live version, or download it as a separate file for archival purposes.
Comments and threaded discussions have replaced the awkward cell notes of earlier Excel versions. Right-click any cell and choose New Comment to start a conversation. You can @-mention specific teammates by typing @ followed by their name, which sends them an email notification with a deep link directly to the cell in question. Threads can be marked as Resolved when the discussion concludes, keeping your workbook clean. This is invaluable during financial close cycles when auditors need to ask questions about specific line items.
The Show Changes feature reveals exactly who modified what and when. Open the Review tab and click Show Changes โ a pane appears listing every edit in reverse chronological order with the editor's name, the cell reference, the old value, and the new value. You can filter by user, by date range, or by sheet. This is the modern replacement for the deprecated Track Changes feature and works seamlessly with co-authoring.
For workbooks where multiple teams need to work in parallel without stepping on each other, consider splitting work by sheet. Assign one sheet per team or per person and protect the other sheets so only authorized users can edit them. Protected sheets still allow viewing, so everyone retains a full picture of the workbook while changes are isolated. Combine sheet protection with cell-level locking for the finest-grained control over what each collaborator can touch.
If you frequently work with the same group of people, save them as a sharing group inside OneDrive. Go to the OneDrive web interface, open Settings then More Settings, and create reusable contact groups. Next time you share a workbook, you can grant access to the entire group in one click. This is especially helpful for departments that share dozens of files per week.
Finally, take advantage of integration with Microsoft Teams. Pin frequently used shared workbooks as Teams tabs, set up Power Automate flows that notify a channel when specific cells change, and use Teams meetings to walk through a shared workbook live with screen sharing turned off โ everyone can see the live document and edit it themselves rather than watching one person scroll.
By default, many organizations allow external sharing with Anyone With The Link, which means a forwarded URL grants access to people you never intended to invite. Always change the link type to Specific People when sharing sensitive workbooks. Also verify that your tenant's external sharing policy matches your compliance requirements โ your IT administrator can lock down external sharing at the tenant level if needed.
Even with modern co-authoring, sharing a workbook in Excel occasionally fails. The most common error is the dreaded This file is locked for editing message, which appears when someone has the workbook open in the legacy desktop client without AutoSave enabled. The fix is straightforward: ask the other user to close the file, or turn on AutoSave so the lock is released automatically. If the user is unreachable, the file owner can force-close the session from the SharePoint admin center.
Another frequent issue is sync conflicts on identical cells. If two users edit the same cell within milliseconds of each other, Excel keeps both versions in the version history and prompts you to choose which one to keep. This rarely happens in practice because the sync delay is so short, but when it does the resolution dialog is clear and easy to follow. To minimize conflicts, divide your workbook into logical zones and assign zones to specific collaborators rather than letting everyone edit everywhere.
Permissions errors usually come from one of three sources: the recipient is not signed into the correct Microsoft account, the share link has expired, or your organization's external sharing policy blocks the recipient's domain. Walk through these systematically. Ask the recipient to confirm which account they used to open the link, check the link expiration date in the Share dialog, and contact your IT team if the domain is blocked.
Some Excel features do not survive the journey to the cloud. Legacy ActiveX controls, certain XLM macros, and external workbook links to local file paths all break when a workbook moves to OneDrive. Before sharing, run File then Info then Check for Issues then Check Compatibility to surface any features that may cause problems. Replace deprecated elements with modern equivalents โ for example, swap legacy form controls for the newer Form Controls in the Developer tab.
Performance can degrade in extremely large shared workbooks, particularly those exceeding 50 MB or containing thousands of volatile formulas like NOW, TODAY, INDIRECT, and OFFSET. If sync feels sluggish, audit your formulas for volatility, convert volatile calculations to static values where possible, and consider splitting one massive workbook into several smaller linked files. Power Query connections to external data also slow down sync if they refresh on every open โ schedule refreshes instead.
If you previously used the legacy Shared Workbook feature and want to migrate to modern co-authoring, the process is simple. Open the workbook, go to Review then Unshare Workbook, save the file to OneDrive, and reshare using the modern Share button. You will gain access to all the features the legacy mode disabled, including tables, advanced conditional formatting, and modern functions. Just verify no users are mid-edit when you flip the switch.
When all else fails, the Excel Help system and the Microsoft 365 admin center provide detailed diagnostic logs. Look for sync errors in the OneDrive activity feed, check the Microsoft 365 service health dashboard for outages, and consult your IT team if a problem persists across multiple users. Most sharing issues resolve within minutes once the root cause is identified, but stubborn cases occasionally require Microsoft support tickets.
Now that you understand the mechanics of sharing, let's cover the practical habits that separate casual users from true Excel collaboration experts. First, develop a consistent naming convention for shared workbooks. Use the pattern Department_ProjectName_YYYYMMDD or similar so that anyone glancing at OneDrive can instantly identify what a file contains and how recent it is. Avoid ambiguous names like Final_v2 or Copy of Budget โ these accumulate quickly and create confusion.
Second, document your workbook structure on a dedicated cover sheet. Include a table of contents listing every worksheet, a legend explaining color codes and conditional formatting, a changelog showing major revisions, and contact information for the workbook owner. New collaborators can orient themselves in seconds instead of asking questions that interrupt your day. Pin this cover sheet as the first tab and consider locking it with sheet protection so nobody accidentally modifies the documentation.
Third, build strong data validation into shared workbooks. Use drop-down lists for any field where values must come from a controlled set, apply input restrictions on numeric ranges, and provide helpful error messages that explain what valid input looks like. This prevents the most common form of collaboration damage: well-intentioned teammates typing inconsistent values that break downstream pivot tables and formulas. Validation is your guardrail.
Fourth, separate input from calculation from output. Reserve specific sheets for raw data entry, others for calculations and intermediate formulas, and a final set for dashboards and reports. Lock the calculation sheets so only the workbook owner can edit them, leaving collaborators free to update inputs without risking your logic. This three-layer architecture scales gracefully from small team trackers to enterprise financial models.
Fifth, monitor activity regularly. Once a week, open Version History and skim through recent changes to verify everything looks reasonable. Look for unexpected formula edits, deleted rows, or unusual value patterns. Catching mistakes early โ before they propagate into downstream reports โ saves enormous amounts of cleanup time. The Show Changes pane in the Review tab makes this audit trivially quick.
Sixth, periodically clean up sharing permissions. People change roles, projects end, and contractors finish their engagements, but their access often lingers indefinitely if nobody removes it. Set a calendar reminder to audit shared workbooks quarterly. For each file, open the Share dialog, review the list of people with access, and remove anyone who no longer needs it. This is basic security hygiene that prevents data leaks down the road.
Finally, invest in continuous learning about MS Excel collaboration features. Excel updates frequently, and Microsoft adds new collaboration features almost every month. Subscribe to the Microsoft 365 release notes, follow the Excel team on social media, and bookmark the Microsoft Learn library. Try our practice quizzes regularly to keep your knowledge sharp on related skills like remove duplicates excel workflows, Excel shortcuts, and how to merge cells in Excel cleanly without losing data โ all of which come into play when you share workbooks with diverse teams.
Excel Co-Authoring in Real Time: What Actually Happens
When people search for excel co-authoring in real time, they usually want to know what happens the instant two people touch the same workbook. Here is the short version: once a workbook lives on OneDrive or SharePoint and AutoSave is on, every keystroke syncs to Microsoft's servers within a second or two, and every other open session receives that update almost immediately. You do not need to save manually, and you do not need to refresh the file. Microsoft Excel and Excel for the web use the same underlying sync engine, so a colleague working in the desktop app and another working in a browser tab see each other's changes at the same speed.
Each active collaborator shows up as a small colored initial near the top of the ribbon, and a matching colored flag appears next to any cell they are currently editing, so you always know who is working where before you click into a cell yourself. If your workbook still uses the old Shared Workbook (Legacy) mode instead of cloud co-authoring, you will not get this real-time behavior at all โ that mode requires everyone to save manually and merge changes, which is exactly why Microsoft recommends switching every workbook to modern co-authoring. In practice, real-time sync combined with automatic version history is what makes it safe to let a whole team edit the same Excel file at once without a single emailed copy.
How to Collaborate in Excel Online (Browser Only)
To collaborate in Excel online, save the workbook to OneDrive, OneDrive for Business, or a SharePoint Online library, open it in Excel for the web, select Share, and invite people with edit access. Everyone who opens the link in a browser edits the same live copy, with no desktop install required.
A few rules decide whether real-time co-authoring works. The file must be in .xlsx, .xlsm, or .xlsb format; older .xls files must be re-saved first. Workbooks stored on SharePoint On-Premises (servers not hosted by Microsoft) do not support co-authoring. AutoSave is always on in the browser, so changes sync automatically instead of waiting for a manual save.
While you work, each collaborator appears as a picture or initials in the upper-right corner (a "G" marks a guest). Their selected cells show in colors such as blue or purple, while your own selection always shows in green. Hover over a colored selection to see the person's name, or use threaded comments with @mentions to ask a question about a specific cell.
If something goes wrong, open File > Info > Version History to view or restore an earlier copy. Microsoft recommends waiting until others have stopped co-authoring before restoring a version.
Best Ways to Collaborate in Excel Online
The best ways to collaborate in Excel online combine live co-authoring with a few communication tools built into the workbook. Open the shared file in Excel for the web, and you will see each collaborator's name or initials and their selected cells in real time, so nobody types over the same range by accident. Use threaded comments to ask a question about a specific cell: type @ followed by a teammate's name and they receive a notification with a link to that comment. Mark the thread as resolved when the question is answered.
To review what changed, open the Review tab and use Show Changes, which lists recent edits with the editor and the cell involved. Use Version History under File then Info if you need to compare or restore an earlier copy. For larger teams, split the work by sheet, agree on who owns the formulas, and keep inputs, calculations, and reports on separate tabs so people can edit at the same time without breaking each other's work.
๐ What replaced the old Shared Workbook feature in Excel?
Modern real-time co-authoring through OneDrive or SharePoint replaced the legacy Shared Workbook feature. Co-authoring supports 100+ simultaneous editors, full formula support, and automatic version history, while the legacy mode disables tables, dynamic arrays, and several modern functions.
START EXCEL PRACTICE TESTโ๏ธ Do I need OneDrive or SharePoint to co-author a workbook?
Yes. Co-authoring only works once the workbook is saved to OneDrive, SharePoint, or a Microsoft Teams channel (which is built on SharePoint). A file saved only to a local drive or a network share cannot sync edits between collaborators in real time.
START EXCEL PRACTICE TEST๐ Is Track Changes still available in Excel?
The classic Track Changes command from the legacy Shared Workbook feature still exists for older files, but modern co-authored workbooks use Show Changes instead, found on the Review tab. Show Changes lists every edit with the editor, cell, old value, and new value.
START EXCEL PRACTICE TEST๐ Can I protect part of a workbook before sharing it?
Yes. Use Review then Protect Sheet to lock specific worksheets, or apply cell-level protection through Format Cells then Protection. This lets collaborators view or edit only the areas you choose while your formulas and structure stay safe.
START EXCEL PRACTICE TEST๐ฅ How many people can co-author an Excel workbook at once?
Microsoft 365 supports real-time co-authoring by more than 100 simultaneous users on a single workbook. In practice, most shared workbooks have far fewer active editors, but the platform is built to handle large teams without slowing down sync.
START EXCEL PRACTICE TEST๐ How does Excel version history help with shared workbooks?
OneDrive and SharePoint automatically save up to 500 versions of a co-authored workbook. You can open File then Info then Version History to preview, restore, or download any earlier version, which makes it safe to let a whole team edit the same file.
START EXCEL PRACTICE TEST๐ง What happens if I share a workbook as an email attachment instead?
An emailed attachment is a static snapshot, not a live shared file. Recipients can edit their own copy, but none of their changes sync back to your original, and you have to manually merge any updates. Use attachments only when the recipient has no Microsoft 365 or OneDrive access.
START EXCEL PRACTICE TEST๐ What is the safest way to share a workbook with people outside my company?
Use the Specific People option in the Share dialog so the link only opens for the exact email addresses you list, add an expiration date, and consider turning on Block Download for highly sensitive data. This is safer than a generic Anyone With The Link share.
START EXCEL PRACTICE TEST๐ Can someone without Microsoft 365 open a shared Excel workbook?
Yes. Anyone with a free Microsoft account can open a shared workbook in Excel for the web and get most viewing and editing features at no cost. Only advanced desktop-only functions may be limited in the free browser version.
START EXCEL PRACTICE TEST๐ซ How do I completely stop sharing a workbook?
Open the workbook, click Share, then Manage Access. From there you can remove individual people, disable specific links, or click Stop Sharing to revoke every share link at once. Removed collaborators lose access immediately, even if they saved the link.
START EXCEL PRACTICE TESTSample Excel Practice Questions
Try these questions from our free Excel practice tests. The correct answer and an explanation follow each question.
Which function returns the current date and time, updating each time the workbook recalculates?
- A. TODAY()
- B. DATE()
- C. NOW()
- D. TIME()
Answer: C. NOW()
NOW() returns the current date and time as a serial number that recalculates whenever the worksheet changes.
What is the difference between a workbook and a worksheet in Excel?
- A. A workbook is the entire file containing one or more worksheets; a worksheet is a single tab within that file
- B. A workbook is for data entry and a worksheet is for charts
- C. They are the same thing with different names
- D. A worksheet can contain multiple workbooks
Answer: A. A workbook is the entire file containing one or more worksheets; a worksheet is a single tab within that file
A workbook is the Excel file itself (the .xlsx or .xlsm file), while a worksheet is an individual sheet (tab) within that workbook. One workbook can contain many worksheets.
Which keyboard shortcut saves the current workbook in Excel?
- A. Ctrl+S
- B. Ctrl+W
- C. Ctrl+P
- D. Ctrl+N
Answer: A. Ctrl+S
Ctrl+S saves the active workbook, prompting for a filename if it hasn't been saved before.
Which function returns the current date and time that updates each time the worksheet recalculates?
- A. =DATE()
- B. =TODAY()
- C. =NOW()
- D. =TIME()
Answer: C. =NOW()
NOW() returns the current date and time as a serial number and refreshes every time Excel recalculates.
Take the full Excel practice test
Excel Questions and Answers
Written and edited by Nathan Beja, founder of Practice Test Geeks, with AI assistance. Exam facts are checked against the official sources linked below. Editorial policy
Sources & references
Exam facts on this page (fees, format, dates, passing scores) are checked against these official sources; the date is our last check. Editorial policy
- learn.microsoft.com โ Retake policy, test delivery, time limit, eligibility ยท verified Oct 2026
- certiport.pearsonvue.com โ Exam format, score validity, passing score, score release, exam information ยท verified Oct 2026




