M365Con 2027 – free online conference · 11–22 Jan 2027 · 120 sessions m365con.net

Blog · Mirko Peters

How to find files that are shared with everyone

Disclosure: Cognillo sponsors M365.FM. This page describes the company factually; paid partnerships and links are labelled as advertising.

By ·

Files shared with everyone often go unnoticed until someone searches for them. Learn where to look with built-in Microsoft 365 reports, what those reports leave out, and when a third-party tool can help.

Some files are open to far more people than anyone intended. A document gets shared with the whole organization for a quick review, a link is created for convenience, and months later nobody remembers it exists. The file is still there, still reachable, and nobody is watching it.

This article shows how to find that content with built-in Microsoft 365 reports, what those reports do not tell you, and where a third-party tool can fit in.

What "shared with everyone" actually means

In practice, the term covers several situations. The best known is content shared with the group Everyone except external users, which covers internal users in the organization (check Microsoft Learn for the exact scope). Others are organization-wide sharing links, which work for signed-in people in the organization who have the URL, and Anyone links, which work for anyone who has the URL.

Oversharing is the broader concept: content shared more widely than intended. It matters for security and privacy, and it matters more with AI assistants. AI assistants such as Copilot can surface content to users who already have access to it, so content that is open too widely can show up in places the owner never expected.

Imagine a team site for a project that ended two years ago. The team shared a planning folder with the whole organization to collect feedback once. Nobody removed the permission. Depending on how the permission was set, a search by an unrelated employee could surface those files. No one did anything wrong recently, but the exposure may still be real.

Start with the built-in reports

SharePoint reporting is the natural first step because it uses Microsoft's own features. Note that the data access governance reports need the licensing described in the SharePoint Advanced Management prerequisites. Microsoft Learn describes two kinds of reports.

Data access governance reports live in the SharePoint admin center under Reports, Data access governance. They require the SharePoint administrator role plus the licensing from the SharePoint Advanced Management prerequisites. There are two types:

  • Snapshot reports show data as of the day they were created. Microsoft Learn lists site permissions across the organization, site permissions for users, sites and files shared via special SharePoint groups, and sensitivity labels applied to files.
  • Activity reports cover the last 28 days. Microsoft Learn names sharing links and content shared with "Everyone except external users".

Microsoft recommends running snapshot reports quarterly and activity reports monthly. For organizations without SharePoint Advanced Management, activity reports need data collection to be enabled first, and collection pauses if no report is generated for three months. A one-off run shows one point in time; the cadence above is what gives you a continuous picture.

To see exactly which items are affected, use the snapshot report Sites and files shared via special SharePoint groups. It lists every item where "Everyone except external users" or "Everyone" is a recipient, with the permission level and the parent group when access is indirect. You find it under Reports, Data access governance, Snapshot reports. Microsoft Learn lists these conditions: the SharePoint Advanced Management Administrator role, which a Global administrator assigns; the site permissions for your organization report generated at least once; one report for SharePoint and OneDrive together, with no scoping to a single site; a download of up to 1 million rows; and a re-run every 30 days at the earliest. System files and system groups are not included.

Check the SharePoint documentation on Microsoft Learn for the current requirements and report list, since licensing and features can change.

Use the single-site report for a closer look

When you already suspect a specific site, a site admin can create a CSV report of every unique file, user, permission and link on that SharePoint site or OneDrive. The file is saved on the site itself, and Microsoft suggests keeping it in a folder that only site owners can access. The details are in the sharing reports page on Microsoft Learn.

Read the limits before you rely on it:

  • It does not include Anyone links.
  • It does not include links that were e-mailed but not clicked.
  • It shows SharePoint groups, but not the individual people inside them.

That last point matters. A report line that says a folder is shared with a group tells you the group, not who is in it. If that group is large, the real exposure is hidden one level down. For wider analysis across many sites, Microsoft Learn points to Microsoft Graph Data Connect.

Where a third-party tool can fit

Built-in reports give you a view. Acting on what you see, across many sites, is a different task, and some organizations look at third-party tools for it. These are one option among several; whether one is needed depends on your size, licensing and how much work you want to do with scripts and the admin center.

One example is the SharePoint Essentials Toolkit from Cognillo, which sponsors M365.FM. According to the vendor's product page, it includes a report on oversharing and Copilot readiness covering sharing links, sites and content open to everyone, heavily shared files that are not labelled, and outdated content with open access. The page also describes permission reports for sites, folders and items, a view of everything one person can access, and the ability to fix permissions and sharing links from reports. Reports can be scheduled and exported to SharePoint, by e-mail, or to Excel or CSV. Any fixes made from reports change access, so the test-first and way-back advice below applies to them as well.

These are the vendor's own statements and were not tested by M365.FM. The vendor also names a free Community Edition limited to 20 SharePoint sites, which could be one way to try a tool on a small scope. Prices and editions change, so check the product page for current details. The review site TrustRadius lists ShareGate and LinkFixer Advanced as common alternatives, so compare options against your own requirements.

Clean up carefully

Finding the content is the easy part. Removing access is where things go wrong.

Removing a link or permission can immediately cut off people who depend on it: a department that reads a shared folder, a process that relies on a link, or a partner who needs a document. Bulk changes multiply that risk.

Before you change anything:

  • Test first on a pilot site or in a test tenant, not on production content.
  • Keep a way back. Export the current permissions and links before you change them, and make sure you know how you would restore access if something breaks. Check Microsoft Learn for what your tenant's backup and restore options cover, and do not assume a removed permission or link can be restored automatically.
  • Change in small batches and tell site owners what you are doing and why.

A sensible order is to start with the sites where the content is most sensitive, ask the owner whether the sharing is still needed, and only then remove it. Owners know the context; reports do not.

Practical takeaways

  • Define the problem: "shared with everyone" can mean the Everyone except external users group, organization-wide links or Anyone links. Search for each separately.
  • Start with the admin center: data access governance reports need the SharePoint administrator role plus the licensing from the SharePoint Advanced Management prerequisites, and the item-level report needs the SharePoint Advanced Management Administrator role. Run snapshot reports quarterly and activity reports monthly, as Microsoft recommends.
  • Use the single-site CSV report for detail, but remember it omits Anyone links, unclicked e-mailed links and the members of SharePoint groups.
  • Do not rely on one report. Combine sources to get a fuller picture.
  • Consider a tool only if you need one. Compare options against your size, licensing and workload, and test any tool on a small scope first.
  • Test and keep a way back before removing permissions or links, and involve site owners before you change anything.

Sources

FAQ

What does 'Everyone except external users' mean in SharePoint?

It is a built-in group that covers internal users in your organization. If a site, folder or file is shared with this group, internal users can open it, whether or not that was intended. External users are not included, which is where the name comes from. Check Microsoft Learn for the exact scope in your tenant.

Which built-in report shows content shared with everyone?

The data access governance reports in the SharePoint admin center cover it. The EEEU activity report shows sites where content was shared with all internal users in the last 28 days, and the snapshot report Sites and files shared via special SharePoint groups lists the individual items shared with 'Everyone except external users' or 'Everyone'. They need the SharePoint administrator role plus the licensing from the SharePoint Advanced Management prerequisites, and the item-level report needs the SharePoint Advanced Management Administrator role. Check Microsoft Learn for the current requiremen

Does the single-site CSV report show all sharing links?

No. According to Microsoft Learn, the report for a single site does not include Anyone links or links that were e-mailed but not clicked. It also shows SharePoint groups but not the individual people inside them. Treat it as a useful starting point, not a complete inventory.

Entities in this article

Topics of this article:

Oversharing – Concept SharePoint reporting – Concept SharePoint Essentials Toolkit – Product by Cognillo

Related articles

More articles on Oversharing:

RSS