Tag: co-authoring

Excel 2021 features displayed on a laptop with XLOOKUP formulas highlighted
September 10, 2026

Excel 2021 Features Most Users Never Touch (But Should)

Post By administrator Microsoft, Office , , , , No Comments

The most powerful Excel 2021 features are hiding in plain sight — and once you know them, you will never go back to the old way of building spreadsheets. From XLOOKUP replacing decades-old VLOOKUP workarounds to dynamic arrays that spill results automatically, Excel 2021 represents the biggest functional leap the application has seen in years. This guide walks through every major tool, with practical examples, so you can start using them today.

Why Excel 2021 Features Represent a Genuine Step Change

Excel 2021 functions overview showing XLOOKUP FILTER SORT and LET icons

Excel has always been powerful, but earlier versions required elaborate workarounds for tasks that should be simple — nested IFs, helper columns, array-entered Ctrl+Shift+Enter formulas, and fragile VLOOKUP chains. Excel 2021 ships with over a dozen new functions and a completely redesigned calculation engine for arrays. According to Microsoft’s official What’s New in Excel 2021 documentation, key additions include XLOOKUP, LET, FILTER, SORT, SORTBY, UNIQUE, SEQUENCE, and XMATCH — all of which work with the new dynamic-array engine natively. The result: formulas that are shorter, faster to write, easier to audit, and more resilient when data changes.

Excel XLOOKUP: The End of VLOOKUP

Excel XLOOKUP is the single most impactful addition in Excel 2021. It replaces VLOOKUP, HLOOKUP, and the classic INDEX/MATCH combination with one clean function that searches in any direction, returns entire rows or columns, handles missing values gracefully, and supports wildcard and approximate matching natively.

Basic Excel XLOOKUP Syntax

The function takes three required arguments and three optional ones:

=XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode])

Where VLOOKUP forced you to count a column number and could only look right, XLOOKUP lets you point at any return range — left, right, above, or below the lookup column. The [if_not_found] argument replaces the clunky IFERROR wrapper that used to be mandatory.

Excel XLOOKUP vs VLOOKUP at a Glance

  • Direction: XLOOKUP searches left, right, or vertically — VLOOKUP only looks right.
  • Column index: XLOOKUP uses a direct range reference — no fragile column number to maintain.
  • Missing values: XLOOKUP has a built-in [if_not_found] argument — no IFERROR needed.
  • Multiple returns: XLOOKUP can return an entire row or column in one formula.
  • Wildcard matching: XLOOKUP supports wildcards via match_mode 2 without helper columns.

For anyone still relying on VLOOKUP in 2025, switching to Excel XLOOKUP alone can cut formula complexity by 30–50% in typical reporting workbooks.

Excel Dynamic Arrays: One Formula, Many Results

Excel XLOOKUP versus VLOOKUP comparison diagram highlighting Excel 2021 features

Excel dynamic arrays are the engine underneath most of Excel 2021’s new Excel 2021 functions. Before this update, a formula could only return a single value to a single cell. Dynamic arrays break that limit — a single formula can now “spill” results automatically into as many adjacent cells as the output requires. No Ctrl+Shift+Enter, no pre-selecting a range.

The Spill Operator (#)

When a dynamic array formula spills into a range, Excel names that range with a # symbol. For example, if your SORT formula in A1 spills results into A1:A50, you can reference the entire spill range elsewhere with =A1#. This makes chaining formulas together far simpler and means downstream formulas automatically adjust when the source data grows or shrinks.

FILTER: Replace Complex Multi-Condition Logic

The FILTER function is one of the most practically useful Excel 2021 functions. Instead of building a pivot table or writing a SUMPRODUCT formula to extract a subset of data, you can write:

=FILTER(A2:D100, (B2:B100="London")*(C2:C100>5000), "No results")

This returns every row where the city is London AND the value exceeds 5,000 — in one formula, updating live as data changes. It completely eliminates the need for Advanced Filter or manual copy-paste workflows.

SORT and SORTBY: Real-Time Sorted Outputs

SORT returns a sorted copy of a range as a spilled array. SORTBY extends this by letting you sort by a column that isn’t even in the output range. Both update instantly when source data changes — no refreshing pivot tables, no re-sorting manually.

UNIQUE: Deduplicate in a Single Step

The UNIQUE function extracts distinct values from a list as a dynamic spill. Combined with SORT, you get a live, automatically sorted, deduplicated list that a single formula maintains. Before Excel 2021, this required Power Query or a VBA macro for most users.

The LET Function: Name Your Calculations

LET is arguably the most overlooked of all the new Excel 2021 functions. It lets you assign a name to any calculation result within a formula, then reuse that name multiple times. This has two major benefits: it makes complex formulas dramatically easier to read, and it prevents the same sub-calculation from being evaluated more than once — which can measurably speed up recalculation in large workbooks.

A practical example — without LET:

=IFERROR(INDEX(B2:B100,MATCH(1,(A2:A100=G1)*(C2:C100=G2),0)),"Not found")

The same logic with LET:

=LET(data_range, A2:C100, match_row, MATCH(1,(INDEX(data_range,,1)=G1)*(INDEX(data_range,,3)=G2),0), IFERROR(INDEX(data_range,match_row,2),"Not found"))

Each named variable is calculated once. In a workbook with thousands of rows and dozens of interdependent formulas, that efficiency compounds quickly.

SEQUENCE: Generate Number Series Automatically

Excel 2021 LET function formula with named variables shown in spreadsheet

SEQUENCE generates an array of sequential numbers in a specified number of rows and columns. It sounds simple, but it unlocks sophisticated patterns when combined with other dynamic array functions — generating date series, building dynamic lookup tables, or creating row numbers for structured outputs without manual entry.

=SEQUENCE(12, 1, DATE(2025,1,1), 30)

This produces 12 dates spaced 30 days apart starting from 1 January 2025 — a complete date spine for a monthly report in a single formula.

XMATCH: The Smarter Match Function

XMATCH replaces the older MATCH function with a cleaner syntax, support for wildcards, and a search-mode argument that lets you search from the end of a list or use binary search for sorted data. Binary search mode is particularly valuable for performance in very large datasets — it runs in O(log n) time rather than scanning every row sequentially.

Smart Recalculation and Performance Gains

Beyond individual functions, Excel 2021 features an improved smart recalculation engine. Excel only recalculates cells whose inputs have actually changed, rather than recalculating entire dependency chains. In workbooks with large datasets and complex formulas, this can reduce recalculation time significantly. Combined with LET (which avoids duplicate sub-calculations) and dynamic arrays (which replace many volatile helper-column formulas), real-world recalculation speed improvements of 20–40% are commonly reported by heavy Excel users migrating from Excel 2016 or 2019.

Excel 2021 Features vs Excel 2019: What You Actually Gain

If you are still running Excel 2019, here is what you are missing compared to the full Excel 2021 features set:

  • XLOOKUP, XMATCH — not available in 2019
  • LET — not available in 2019
  • Dynamic array spill behaviour — not available in 2019
  • FILTER, SORT, SORTBY, UNIQUE, SEQUENCE — not available in 2019
  • Sheet view for collaboration — not available in 2019
  • Improved performance engine for smart recalculation

Excel 2019 does include some improvements over 2016 (IFS, SWITCH, TEXTJOIN, CONCAT), but the gap between 2019 and 2021 is arguably larger than 2016 to 2019 because of the dynamic-array engine underpinning so many of the new functions.

How to Access Excel 2021 Features Without a Subscription

One of the most common misconceptions is that you need a Microsoft 365 subscription to access these Excel 2021 features. You do not. Office 2021 is a perpetual, one-time purchase that includes the full Excel 2021 feature set permanently — no monthly fee, no renewal. BuyNowKey offers Microsoft Office 2021 Professional Plus for Windows with lifetime activation from €28.90, and Microsoft Office 2021 Home and Business for Mac from €69.90 — both as genuine, globally licensed keys with a single activation. For users who want both a new operating system and Office in one transaction, the Windows 11 Home and Office 2021 Professional Plus bundle is available from €34.50 (regular €44.50).

Tips for Putting Excel 2021 Functions to Work Immediately

  • Start with XLOOKUP: Identify every VLOOKUP in your most-used workbooks and replace them one by one. The syntax takes 10 minutes to learn.
  • Use FILTER for reporting: Replace any pivot table that exists purely to filter a dataset — FILTER is faster to build and automatically refreshes.
  • Wrap complex formulas in LET: Any formula longer than 80 characters is a candidate. Name intermediate steps and your future self will thank you.
  • Chain SORT + UNIQUE: A live, sorted unique list in one formula replaces countless manual workflows.
  • Learn the # spill reference: Once you understand how to reference a spill range, you can chain dynamic formulas together fluidly.

Frequently Asked Questions

Are Excel 2021 features available without a Microsoft 365 subscription?

Yes. All the Excel 2021 features described in this guide — XLOOKUP, dynamic arrays, LET, FILTER, SORT, UNIQUE, SEQUENCE, and XMATCH — are included in the perpetual Office 2021 licence. You pay once and own the software with no recurring subscription required. Microsoft 365 subscribers receive the same features, plus access to future updates as they roll out, but Office 2021 gives you everything covered here permanently.

What Is the Difference Between Excel XLOOKUP and VLOOKUP?

VLOOKUP can only search the leftmost column of a range and return a value to the right, requires a column index number, and needs an IFERROR wrapper to handle missing values cleanly. Excel XLOOKUP searches in any direction, references the return range directly, has a built-in missing-value argument, supports wildcard matching natively, and can return an entire row or column in one formula. For almost every use case, XLOOKUP is strictly better.

Do dynamic arrays work in all Excel 2021 editions?

Yes — Excel dynamic arrays and all related functions (FILTER, SORT, SORTBY, UNIQUE, SEQUENCE, XMATCH, LET) are included in every edition of Office 2021, from Home and Student through to Professional Plus. They are also backward-compatible in the sense that the results display correctly in older Excel versions, though the formulas themselves cannot be edited in Excel 2019 or earlier.

Will Excel 2021 dynamic array formulas break in older versions?

If you open a workbook containing dynamic array formulas in Excel 2019 or earlier, the results are displayed as static values but the formulas show as “legacy array formulas” that cannot be edited. It is good practice to keep production workbooks in Excel 2021 or Microsoft 365 if collaborators need to edit those formulas. Sharing read-only or exported outputs to older versions is generally problem-free.

Is LET really worth learning if my formulas already work?

For short, simple formulas — probably not. But for any formula that repeats the same sub-calculation two or more times, LET eliminates redundant computation and makes the formula far easier to audit. In large workbooks with thousands of rows and dozens of interdependent formulas, switching eligible formulas to LET can noticeably reduce recalculation time and significantly reduces debugging time when something goes wrong.

Can I use FILTER and SORT together?

Absolutely — this is one of the most powerful combinations in the Excel 2021 functions toolkit. You can nest SORT inside FILTER to return a filtered, sorted result in a single formula: =SORT(FILTER(A2:D100, C2:C100>1000), 2, 1). This returns all rows where column C exceeds 1,000, sorted ascending by column B — in one line, updating automatically as data changes.

Three free Office alternatives open on laptops: LibreOffice, Google Docs, OnlyOffice
September 9, 2026

Free Office Alternatives in 2026: LibreOffice vs Google Workspace vs OnlyOffice

Post By administrator Office , , , , No Comments

Free Office alternatives have genuinely matured — LibreOffice, Google Workspace’s free tier, and OnlyOffice can each handle real daily work in 2026, but none of them is a perfect drop-in replacement for Microsoft 365. The difference is in the details: formatting fidelity, collaboration features, offline access, and how gracefully each tool handles the file formats your colleagues and clients are already using. This comparison tests all three across the workflows that matter most, so you can choose with your eyes open.

Why People Are Ditching Microsoft 365 in 2026

Bar chart comparing Microsoft 365 cost versus free office suite alternatives

Microsoft 365 subscriptions now start at around €69/year for personal use, and the addition of mandatory Copilot AI features in higher tiers has pushed many users to look for a solid Microsoft Office replacement that costs nothing upfront. At the same time, the three leading free contenders have improved dramatically: LibreOffice 24.x introduced a cleaner UI, OnlyOffice added real-time collaborative editing on par with Google, and Google Workspace’s free consumer apps continue to dominate cloud-based document work globally.

The result is a genuinely competitive market — but “free” can mean subscription-free, open-source, or ad-supported, and each model comes with different trade-offs. Let’s dig into each tool’s strengths and weak spots across real workflows.

LibreOffice: The Open-Source Powerhouse

This is the most feature-complete free office suite available and the default recommendation for users who want full offline capability and no data sent to the cloud. It includes Writer (word processing), Calc (spreadsheets), Impress (presentations), Draw, Base, and Math — a broader toolkit than any rival at this price point.

Documents and Spreadsheets

LibreOffice Writer handles complex documents well: long-form reports with cross-references, footnotes, and multi-level styles all work reliably. Calc is genuinely powerful — it supports the vast majority of Excel functions, pivot tables, and complex conditional formatting. For purely internal workflows where everyone uses it, the experience is excellent.

The problem surfaces when files move between ecosystems. The Document Foundation’s own feature comparison notes that while LibreOffice offers good support for DOCX and XLSX formats, complex formatting — SmartArt, embedded macros, advanced Word styles — can shift or break when round-tripping between LibreOffice and Microsoft Office. In mixed environments, this is a real day-to-day friction point.

Presentations

Impress is functional but falls noticeably behind PowerPoint’s animation engine and the modern template library. If you’re presenting to external clients who open your file in PowerPoint, test every transition and font before the meeting — fonts not embedded in the file, and animation timing differences, are the most common surprises.

Collaboration and Email

Offline work is LibreOffice’s strongest suit; simultaneous co-authoring is its biggest gap. There is no built-in real-time collaboration — multiple users cannot edit the same document at the same time the way they can in Google Docs or OnlyOffice’s cloud edition. For solo users or small teams sharing files by email, this is fine. For remote teams working simultaneously, it’s a deal-breaker. It also has no built-in email client (you’d pair it with Thunderbird).

Who LibreOffice Is Best For

  • Solo professionals and students who work primarily offline

  • Organisations with strict data-sovereignty or privacy requirements

  • Power users who need deep macro support (Basic scripting) or advanced Calc functions

  • Anyone comfortable saving in ODF format rather than relying on DOCX/XLSX round-trips

Google Workspace Free Tier: The Collaboration Leader

The free consumer tier of Google Workspace — Docs, Sheets, Slides, Gmail, Drive — is arguably the most widely used Office alternative on the planet. It excels in one area above all others: real-time collaboration. Multiple people can edit the same document simultaneously, comments resolve inline, and version history goes back as far as you need. For remote teams, this alone justifies the switch.

Documents and Spreadsheets

Google Docs is clean and extremely fast to load, but it deliberately keeps the feature set simple. Advanced paragraph styles, complex tables, and precise print layout are weaker than in LibreOffice Writer or Word. Google Sheets is strong for data analysis and dashboards and integrates natively with Google Data Studio and BigQuery — a legitimate advantage for data-heavy teams. Its formula compatibility with Excel is high for common functions but drops off with specialist financial or engineering formulas.

File import/export is reliable for straightforward documents but suffers from the same formatting drift as LibreOffice with complex Word or Excel files. Google’s conversion engine keeps improving, but intricate layouts still need manual cleanup after import.

Presentations

Google Slides is polished for collaborative decks and has a growing template marketplace. It is best described as “PowerPoint Lite” — more than enough for most business presentations, but lacking advanced animation, fine typography controls, and offline animation fidelity. Slides exports to PPTX reasonably well for simple decks.

Email

Gmail is one of the strongest email clients available at any price, with robust spam filtering, smart compose, and powerful search. For teams already in the Google ecosystem this is a compelling differentiator — no other free office suite bundles an email client of this quality.

The Free Tier’s Limits

  • 15 GB of shared storage across Drive, Gmail, and Photos — fills faster than you’d expect

  • Requires an internet connection for full functionality; offline mode works but is limited

  • No desktop app; browser-only (some users find this restrictive)

  • Privacy-conscious users may be uncomfortable with Google’s data practices

OnlyOffice: The Format-Faithful Middle Ground

OnlyOffice editor showing faithful Microsoft Office replacement document formatting

OnlyOffice positions itself specifically as a Microsoft Office replacement, and its strongest card is native compatibility with DOCX, XLSX, and PPTX formats. Unlike LibreOffice, this software renders these formats using the same layout engine, which dramatically reduces formatting drift when files move to and from Microsoft Office. In practical testing, complex Word documents with tracked changes, nested styles, and multi-column layouts come through almost perfectly.

Documents and Spreadsheets

OnlyOffice Docs (the open-source community edition, which is free to self-host) looks and feels like a web-based Microsoft Office — familiar ribbon, similar keyboard shortcuts, and OOXML-first file handling. This makes the transition from Office substantially easier than LibreOffice’s different UI paradigm. The spreadsheet editor supports collaborative editing in real time — a feature LibreOffice cannot match — and handles Excel functions reliably for most professional use cases.

Presentations

OnlyOffice’s presentation editor is the most Office-like of the three alternatives, rendering PPTX animations and transitions more faithfully than Impress or Slides. If you frequently share presentation files with Office users, this is the safest choice.

Collaboration and Self-Hosting

The community edition requires self-hosting (a Docker instance or a compatible server), which is a technical barrier for non-developers. The cloud-hosted version for teams starts at a paid tier. For organisations willing to self-host, OnlyOffice provides real-time collaboration, commenting, and version history — on a par with Google Workspace — while keeping all files on their own infrastructure. That’s a compelling combination for privacy-focused businesses.

Who OnlyOffice Is Best For

  • Teams that share files heavily with Microsoft Office users and cannot afford formatting errors

  • IT-confident organisations that can self-host for free collaboration without cloud lock-in

  • Small businesses transitioning from Office who need a familiar interface

  • Remote teams that need real-time co-authoring without paying for Google Workspace Business

Head-to-Head: Where Each Tool Wins

Scorecard comparing three free Office alternatives across key workflow categories

Across the four core workflows — word processing, spreadsheets, presentations, and email — here’s how the three free Office alternatives stack up at a glance:

  • Best for offline power users: LibreOffice — deepest feature set, no internet required

  • Best for remote collaboration: Google Workspace free tier — unmatched real-time co-authoring and Gmail

  • Best Office format fidelity: OnlyOffice — most accurate DOCX/XLSX/PPTX handling

  • Best for privacy-first teams: OnlyOffice (self-hosted) or LibreOffice (fully local)

  • Easiest learning curve from Office: OnlyOffice — ribbon UI feels immediately familiar

  • Best email client included: Google Workspace free tier — Gmail is in a class of its own

The Case for a Paid Lifetime Office Licence

If the free alternatives leave gaps your workflow can’t afford — formatting fidelity, macro compatibility, Outlook integration — a one-time Microsoft Office licence can be a smarter investment than a recurring Microsoft 365 subscription. At BuyNowKey, Microsoft Office 2021 Professional Plus for Windows is available for just €28.90 with lifetime activation — no annual renewal, full Word, Excel, PowerPoint, and Outlook. For Mac users, Microsoft Office 2021 Home and Business for Mac starts at €69.90 with account-bound lifetime access. That’s a one-time cost that pays for itself versus a subscription within a single year.

A perpetual licence gives you the gold-standard format compatibility that none of the free alternatives can fully match, without the subscription treadmill.

FAQ: Free Office Alternatives

Is LibreOffice really free, or are there hidden costs?

It is completely free and open-source — no hidden fees, no subscription, and no premium tier. It is developed and maintained by the Document Foundation, a non-profit organisation. You can donate to support development, but it is entirely optional. The full suite, including all future updates, costs nothing.

Can I use Google Docs offline?

Yes, but with limitations. Google Docs, Sheets, and Slides support offline editing via the Google Docs Offline Chrome extension. You must enable offline mode in advance while connected, and syncing happens automatically when you reconnect. The offline experience is functional but less reliable than a fully local application like LibreOffice.

Does OnlyOffice work without internet?

The self-hosted community edition of the program runs entirely on your own server infrastructure, so it works on a local network without internet access. The desktop editors also support offline editing and sync when you reconnect to the server. The cloud-hosted version requires an internet connection.

Which free Office alternative handles Excel macros best?

LibreOffice Calc supports macros written in Basic, Python, and JavaScript, but it does not run Excel VBA macros natively — complex VBA scripts will need to be rewritten. OnlyOffice has limited macro support for JavaScript-based macros. If your workflow depends heavily on VBA macros, none of these free alternatives is a complete replacement; a perpetual Microsoft Office licence is the more practical solution.

Will my colleagues notice if I switch to a free Office alternative?

For simple documents and spreadsheets, probably not. For complex files — detailed Word reports with custom styles, intricate Excel models with VBA, or PowerPoint decks with advanced animations — formatting drift is real and noticeable. OnlyOffice has the highest fidelity for sharing DOCX/XLSX/PPTX files with Office users, followed by LibreOffice, then Google Docs.

Microsoft 365 outage storm cloud breaking cloud service connectivity August 2026
September 2, 2026

Microsoft 365 Outage Recovery: Lessons From August 31, 2026

Post By administrator Microsoft, Office , , , , , , No Comments

The Microsoft 365 outage that struck on August 31, 2026 was a sharp reminder that even the world’s most widely used productivity cloud can go dark without warning. Outlook stopped delivering mail, Teams calls dropped mid-meeting, the Microsoft Store became unreachable, and Azure authentication faltered — all within the same window. More than 26,000 outage reports flooded Downdetector within hours, and the disruption dragged into September 1 before services fully stabilised. If your team relies on Microsoft 365, the question is not whether another outage will happen, but how prepared you will be when it does.

What Happened on August 31, 2026

Infographic of Microsoft 365 outage affected services Outlook Teams Azure August 31 2026

Multiple independent sources, including reports on the incident and community threads on Spiceworks and Reddit, point to a core authentication configuration failure as the root cause. The component responsible for identifying and authenticating users across Microsoft’s cloud estate failed, which meant that even services that were technically operational could not let users sign in. The cascading effect knocked out:

  • Outlook — email sending, receiving, and calendar access all failed for affected accounts
  • Microsoft Teams — messaging, calls, and file sharing became unavailable
  • Microsoft Store — app downloads and licence verifications timed out
  • Azure — admin portals and several Azure-backed services reported authentication blocks
  • OneDrive — file sync stalled for users whose tenants were in the affected region

By 4:36 PM EDT, Microsoft’s own status page acknowledged the problem and engineers began re-examining the authentication layer. According to a Facebook update from a managed-services provider monitoring the incident, user-facing signs included login failures and missing emails — classic symptoms of an auth-plane collapse rather than a storage or network problem at the edge.

The Timeline of the Microsoft 365 Outage

Piecing together community reports and TechCrunch’s follow-up coverage, the incident unfolded roughly as follows:

  1. ~12:00 PM EDT — First user reports of Outlook and Teams access failures begin appearing on Downdetector.
  2. ~1:30 PM EDT — Volume of reports spikes past 10,000; Reddit’s r/technology thread goes viral as IT admins confirm the problem is tenant-wide, not local.
  3. ~3:00 PM EDT — Azure admin portals confirm authentication degradation; Microsoft begins internal investigation.
  4. ~4:36 PM EDT — Microsoft posts a public status update acknowledging the authentication configuration issue and stating engineers are re-examining remediation steps.
  5. Evening EDT (Aug 31) — Partial service restoration begins for some regions; other tenants remain impacted.
  6. September 1, 2026 — TechCrunch reports that degradations are still visible but improving; full stabilisation confirmed later that day.

Why Microsoft 365 Outage Recovery Takes Longer Than You Expect

Effective 365 outage recovery is rarely instant, and this incident illustrates why. When authentication infrastructure is the failure point, every dependent service — mail, chat, file sharing, licence verification — stays broken until the identity layer is restored. Rolling back a misconfigured authentication component across a globally distributed cloud is not like restarting a server; changes must be validated region by region to avoid creating new problems. Microsoft’s own Service Health and Continuity documentation notes that after recovery from catastrophic outages there may be a period before full data-centre redundancy is restored — which is precisely what users experienced overnight into September 1.

How to Monitor Microsoft 365 Service Health in Real Time

Business user monitoring Microsoft 365 outage recovery via service health dashboard

The fastest way to confirm a Microsoft outage response situation — rather than chasing your IT team in circles — is to go straight to the official source. Microsoft provides two key monitoring tools:

  • Microsoft 365 Admin Centre → Health → Service Health — shows active incidents, affected workloads, and estimated resolution times. Admins can subscribe to email or webhook alerts so they are notified the moment an incident is posted.
  • Microsoft Service Health Status page — a public-facing dashboard anyone can check without admin credentials. Bookmark it now.

During the August 31 event, admins who had already configured Service Health alerts received incident notifications within minutes of Microsoft’s acknowledgement — giving them a head start to activate their fallback workflows before end users started raising tickets.

Practical Steps for Microsoft Outage Response

Good Microsoft outage response planning does not require a big IT budget — it requires thinking through your communication and workflow dependencies before a crisis hits.

1. Set Up Service Health Alerts Now

In the Microsoft 365 Admin Centre, navigate to Health → Service health → Preferences and enable email notifications for all workloads your business uses. Add multiple recipients — not just the IT lead — so no single point of failure exists in your alert chain.

2. Define Your Fallback Communication Channel

If Teams goes down, what does your team use? During this outage, businesses with a secondary channel — a WhatsApp group, a Slack workspace, even a pre-agreed SMS chain — kept working while others fell silent. Document the fallback and share it with every team member before you need it.

3. Export Critical Data Locally

Cloud sync is convenient until cloud service downtime cuts access entirely. Train staff to keep working copies of in-progress documents locally, or configure scheduled OneDrive sync checkpoints so the most recent version is always available offline.

4. Test Your Backup Email Route

Many organisations have a secondary MX record or a backup SMTP relay that is never tested until it is desperately needed — and is often misconfigured. Run a quarterly test of your contingency email path so you know it actually works.

5. Document Your Incident Response Playbook

Write a one-page document that answers: who confirms the outage is Microsoft-side, who notifies staff, who communicates to customers, and at what point do you escalate to a managed IT provider? Having the answers pre-written saves 30-60 minutes of chaos at the start of every incident.

Cloud Service Downtime and the Case for a Hybrid Approach

Comparison of local Office install versus cloud service downtime impact on productivity

The August 31 outage reignited a debate many IT decision-makers have been quietly having: should every business workflow be 100% cloud-dependent? Cloud service downtime events are statistically rare, but their business impact — halted sales calls, delayed customer responses, missed deadlines — is disproportionately large when they do strike. A hybrid model, where core productivity tools run locally while collaboration features live in the cloud, provides a meaningful safety net.

One practical option is a perpetual-licence Office suite installed locally on each machine. Apps like Word, Excel, PowerPoint, and even a locally cached version of Outlook continue to function during a Microsoft 365 outage because they do not depend on cloud authentication to operate. You can still read, draft, and format documents even when the cloud is unavailable. For a detailed cost comparison of the subscription versus perpetual approach, our article on the Office 2024 lifetime licence versus Microsoft 365 breaks down the real five-year numbers.

If you want the full suite — Word, Excel, PowerPoint, Outlook, Access, and Teams — without a recurring subscription, Office 2024 Professional Plus for Windows is available from BuyNowKey for a one-time payment of €19.95. Having a locally installed suite means your team can keep working through most cloud outages without skipping a beat.

What Microsoft Should Do Differently

Criticism of Microsoft’s handling of the August 31 event centres on two themes: speed of communication and transparency of root-cause information. IT admins reported that they were diagnosing the problem through Downdetector and Reddit before an official status update was posted — a roughly 3-4 hour gap that left businesses in the dark. For an organisation serving hundreds of millions of users, that communication lag is unacceptable.

Industry observers expect Microsoft to publish a full Post-Incident Review (PIR), as it has done after previous major outages. The PIR will detail the root cause, the timeline from detection to resolution, and the engineering changes introduced to prevent recurrence. Watch the Microsoft 365 Admin Centre’s Message Centre for that report — it is typically published within two weeks of a major incident and is essential reading for any business that depends on the platform.

365 Outage Recovery Checklist: Quick Reference

Use this quick-reference list to validate your readiness for the next Microsoft 365 outage event:

  • ✅ Service Health email alerts configured for all Microsoft 365 workloads
  • ✅ Fallback communication channel (non-Teams) documented and shared with all staff
  • ✅ Critical files synced locally via OneDrive offline mode
  • ✅ Secondary email MX or SMTP relay tested within the last 90 days
  • ✅ Incident response playbook written and stored in a non-cloud location
  • ✅ Perpetual-licence Office apps available as a local productivity fallback
  • ✅ Microsoft status page bookmarked: status.cloud.microsoft

FAQ

What caused the Microsoft 365 outage on August 31, 2026?

Reports from multiple sources indicate the outage stemmed from a failure in the core authentication configuration layer — the component that identifies and authenticates users across Microsoft’s cloud services. When that layer failed, users could not sign in to Outlook, Teams, or Azure-backed services even if those services were otherwise operational. Microsoft confirmed the issue on its status page by late afternoon and engineers worked overnight on remediation.

How long did the Microsoft 365 outage last?

The incident began generating widespread reports around midday on August 31, 2026, and full service stabilisation was not confirmed until September 1, 2026 — making it an approximately 24-hour event for the worst-affected tenants. Some users and regions recovered faster as Microsoft restored services in waves, but degradation persisted into the following morning.

How do I check if Microsoft 365 is down right now?

The fastest method is to visit status.cloud.microsoft, Microsoft’s public service health page. If you are a Microsoft 365 admin, the Admin Centre’s Health → Service Health section gives more granular, tenant-specific information and lets you set up proactive alerts so you are notified the moment an incident is opened.

Does a locally installed Office suite work during a Microsoft 365 outage?

Yes — core apps like Word, Excel, and PowerPoint in a perpetual-licence suite (such as Office 2024 Professional Plus) do not require cloud authentication to run their editing and formatting features. You can continue working on documents locally even when Microsoft’s cloud services are unavailable. The main limitation is that cloud-dependent features like real-time co-authoring and cloud storage access require connectivity to be restored.

What is a Post-Incident Review and where can I find Microsoft’s?

A Post-Incident Review (PIR) is an official document Microsoft publishes after major outages, detailing the root cause, timeline, impact scope, and the changes made to prevent recurrence. Microsoft typically publishes PIRs within two weeks of a significant incident. You can find them in the Microsoft 365 Admin Centre under Health → Message Centre, where they appear as advisory messages. Reviewing the PIR helps IT teams update their own contingency plans accordingly.

Remote team using OneDrive collaboration with real-time co-authoring on multiple devices
September 1, 2026

OneDrive Collaboration: Co-Authoring Tips and Troubleshooting

Post By administrator Microsoft, Office , , , , , , No Comments

OneDrive collaboration lets multiple people edit the same Word, Excel, or PowerPoint file at the same time — no emailing attachments, no overwritten versions, no waiting. Yet many teams use only a fraction of what the feature offers, and a surprising number hit avoidable friction when sync stalls or edits clash. This guide covers everything you need: the right setup, smart permission choices, version control habits, and how to fix the most common co-authoring problems so your remote or hybrid team can actually move faster together.

What Is Real-Time Co-Authoring in OneDrive and SharePoint?

Three steps to enable OneDrive real-time co-authoring in Office applications

Real-time co-authoring means every collaborator sees cursor movements and changes from other editors within seconds — not after a save, not after a refresh. It works across Word, Excel, and PowerPoint when files are stored in OneDrive or a SharePoint document library. Each user’s edits are colour-coded so you always know who is doing what. According to Microsoft’s official co-authoring documentation, the feature requires files to be in a supported format (.docx, .xlsx, .pptx) and AutoSave must be switched on — two requirements that catch many teams off guard when they try to collaborate on older .doc or .xls formats.

Co-authoring works through either the browser-based Office apps or the full desktop Office suite when AutoSave is enabled. The browser route tends to be smoother because there is no local cache to conflict, but desktop apps give you richer formatting and formula tools in Excel.

Setting Up OneDrive Collaboration the Right Way

Getting the foundation right prevents most problems before they start. Follow these steps before sharing any file for collaborative editing.

Store Files in OneDrive or SharePoint — Not on a Local Drive

Co-authoring only activates when the file lives in the cloud. If someone opens a local copy that happens to be synced, they may be editing an out-of-date version. Always open the file directly from the OneDrive or SharePoint URL, or click Open in Desktop App from the browser — this preserves the cloud connection and keeps AutoSave on.

Configure Permissions Before You Share

Permissions control who can edit, who can only view, and who can reshare. In OneDrive and SharePoint you have three main choices:

  • Anyone with the link (edit) — maximum reach, lowest friction, but zero audit trail for external guests. Use only for low-sensitivity files.
  • People in your organisation — the default for most teams. Everyone inside the tenant can open and edit without needing an explicit invite.
  • Specific people — best for sensitive documents. Each collaborator receives a named invite, and you can revoke access individually at any time.

For SharePoint document libraries, you can also set library-level permissions so that every file inside inherits the same rules — less admin than managing individual files.

Enable AutoSave and Choose the Right File Format

AutoSave is the engine behind real-time co-authoring. Switch it on via the toggle in the top-left corner of Word, Excel, or PowerPoint. If the toggle is greyed out, the file is either stored locally or is in a legacy format (.doc, .xls, .ppt). Convert it to the modern format first: File → Save As → OneDrive, then choose the .docx/.xlsx/.pptx format.

Version Control and Change Tracking in Office File Sharing

OneDrive collaboration version history panel showing restorable Office file snapshots

One of the biggest advantages of OneDrive collaboration is automatic version history. Every time AutoSave fires — roughly every few seconds — a new version snapshot is created. You can browse and restore any earlier version without any plugin or manual backup.

How to Access Version History

Right-click the file in OneDrive or SharePoint and choose Version history, or open it in a desktop app and go to File → Info → Version History. Versions are kept for at least 30 days (or up to 500 versions for Microsoft 365 subscribers), so accidental deletions or unwanted bulk changes are almost always recoverable.

Using Comments and @Mentions Instead of Track Changes

Track Changes in Word still works during co-authoring, but it can create noise when several people are editing simultaneously. A leaner approach: use Comments and @mention a colleague’s name to send them an email notification with a direct link to the exact paragraph. This keeps discussion in context and out of the document body. In Excel, use the Notes panel for cell-level annotations without triggering the full review workflow.

Conflict Resolution: What Happens When Two People Edit the Same Cell or Paragraph?

SharePoint co-authoring handles Word and PowerPoint conflicts gracefully — each user edits a different paragraph or slide and changes merge automatically. Excel is more nuanced: if two people type in the same cell simultaneously, Excel flags a conflict and asks each person to choose which value to keep. The resolution dialogue is clear, but it interrupts flow, so teams should establish a loose division of labour for spreadsheets (e.g., each person owns specific columns or sheets).

In PowerPoint, simultaneous edits on the same slide do occasionally cause a “merge conflict” where one person’s change temporarily disappears. The fix: one person should work on the slide while others move to different slides, or use the Outline view to divide work more cleanly.

Fixing Common OneDrive Collaboration Problems

Hybrid team leveraging SharePoint co-authoring and OneDrive collaboration for remote work

Even a well-configured setup hits snags. Here are the most frequent issues and their solutions.

Offline Sync Delays and Stuck Files

If the OneDrive sync client shows a persistent “Processing changes” or “Uploading” status, start here:

  • Pause and resume sync: click the OneDrive icon in the system tray → Pause syncing → wait 10 seconds → Resume syncing.
  • Check file name length. OneDrive enforces a 400-character maximum path length. Files with very long folder structures or special characters (#, %, &) in the name will fail silently.
  • Restart the OneDrive process: close it from the system tray and reopen from the Start menu.
  • Sign out and back in to the OneDrive client to refresh the authentication token.

Co-Authoring Not Appearing or Edits Not Updating

When real-time co-authoring feels like it has stopped — cursors are not visible, changes take minutes to appear — the usual culprit is a broken AutoSave connection. Check the AutoSave toggle at the top of the app. If it says AutoSave Off, click it and follow the prompt to save to OneDrive. If co-authoring still doesn’t activate after that, close the file, wait 30 seconds, and reopen it from the SharePoint or OneDrive URL directly.

A less obvious cause: some organisations restrict co-authoring through Group Policy or sensitivity labels. If AutoSave is permanently greyed out across all files, ask your IT administrator whether the feature is blocked at tenant level.

Slow Updates on Shared Excel Files

Large Excel workbooks with many volatile functions (INDIRECT, OFFSET, NOW()) recalculate on every keystroke, which creates lag during co-authoring. Switch calculation mode to Manual (Formulas → Calculation Options → Manual) while collaborating, then press F9 to recalculate when needed. Also remove any unnecessary conditional formatting ranges — these are a hidden performance drain in shared files.

Best Practices for Remote and Hybrid Teams

SharePoint co-authoring and OneDrive collaboration become genuinely transformative when teams build consistent habits around them — not just technical ones.

Establish a Shared Folder Structure in SharePoint

Scattered files in individual OneDrives are hard to discover and manage. Move collaborative files to a SharePoint document library with a clear folder hierarchy agreed on by the whole team. Use Metadata columns (Project, Status, Owner) rather than deeply nested folders — SharePoint’s filter and search work better on metadata than on folder paths.

Combine Co-Authoring with Microsoft Teams

Opening a SharePoint or OneDrive file directly inside a Teams channel tab keeps conversation and document in the same window. The editing session is still full co-authoring — edits sync in real time — but team members can discuss changes in the channel without switching apps. This is especially useful during hybrid meetings where some people are in a room and others are remote.

Set a File Naming Convention and Retire Email Attachments

The single biggest productivity gain from OneDrive collaboration is eliminating “Final_v3_ACTUALLY_FINAL.docx” chains. Enforce a simple naming convention — ProjectName_DocumentType_YYYYMMDD — and share a link, never an attachment. Anyone opening the link always sees the live version, not a stale copy.

Train the Team on AutoSave and Version History

Most co-authoring problems stem from users not knowing AutoSave is off or not realising version history exists. A 15-minute onboarding walkthrough covering these two features alone eliminates the majority of support requests. Record a short screen-capture video and pin it in your Teams channel so new joiners can self-serve.

Which Office Version Do You Need for Co-Authoring?

Real-time co-authoring in the desktop apps requires a version of Office that supports AutoSave with cloud storage. Office 2016 and later all support co-authoring, though the experience improves noticeably in Office 2021 and Office 2024 thanks to faster sync intervals and better conflict handling. For the smoothest experience, Microsoft Office 2021 Professional Plus — available from BuyNowKey from €28.90 — includes Word, Excel, PowerPoint, and Outlook with lifetime activation, and pairs seamlessly with OneDrive and SharePoint for full co-authoring support.

If you want the very latest Office feature set, the Office 2024 Professional Plus licence is available from €19.95 and includes Teams alongside the core apps — a natural fit for hybrid teams building a co-authoring workflow.

FAQ

How many people can co-author a document at once in OneDrive?

Microsoft does not publish a hard cap, but the practical limit for a smooth experience is around 10 simultaneous editors in Word and PowerPoint. Excel works best with fewer concurrent editors on the same sheet because of cell-level conflict handling. For larger review cycles, consider splitting the document or using the browser version, which is lighter on resources.

Does OneDrive collaboration work without an internet connection?

The real-time part requires an internet connection — changes sync via the cloud. However, if you lose connectivity while editing a file that is also synced locally, the OneDrive client queues your changes and uploads them automatically when the connection returns. Other collaborators will not see your edits until you are back online.

Can I use co-authoring with people outside my organisation?

Yes. Share the file using the “Specific people” or “Anyone with the link” permission and send the link to external collaborators. They can edit in the browser even without a Microsoft 365 account if you allow it. For sensitive files, require them to sign in with a Microsoft account before gaining access, which keeps an audit trail of who edited what and when.

Why does SharePoint co-authoring keep kicking me out of editing?

This usually happens when a sensitivity label or Information Rights Management (IRM) policy is applied to the file. Some IRM policies disable AutoSave entirely, which breaks co-authoring. Check with your IT administrator to confirm the label settings. Alternatively, the file may be open in Protected View — click Enable Editing to exit Protected View and restore co-authoring.

What’s the difference between OneDrive collaboration and SharePoint co-authoring?

Technically they use the same underlying mechanism — both sync through the Microsoft 365 cloud. The distinction is where the file lives: OneDrive is personal cloud storage tied to your account, while SharePoint is team or organisation-wide storage with richer permission management and metadata. For anything more than two or three people collaborating regularly, SharePoint document libraries are the better home because of their granular access controls and governance features.