how to kick someone out of an excel file

"Ejecting Unwanted Data: Excel Delete Row Tutorial"

By James Miller
AD

Tired of handling messy and large Excel files? Ever wished you could 'kick someone out' of one? Well, you can't physically oust someone from an Excel file, but you can certainly remove or delete them. Here's a guide to help you do that efficiently. We'll cover two main methods: permanently deleting a user and simply removing them from the file's access list.

First, let's dive into why you might want to do this. Perhaps the user's access is no longer needed, or they've left your organization. Maybe they've been misbehaving, and you want to limit their access. Whatever the reason, these steps will help you achieve your goal.

Deleting a User Permanently

This method completely removes a user from your Excel file's list of users and groups. It's a scorched-earth approach, but sometimes necessary.

AD
How to do auto numbering in excel 😱
How to do auto numbering in excel 😱
How to separate information on Excel
How to separate information on Excel
Excel tricks
Excel tricks

Before proceeding, make sure you have the necessary permissions. You'll need to be an administrator or have permission to modify user access.

Using SharePoint Online

SharePoint Online is a component of Microsoft 365 that integrates with Excel. Here's how to delete a user:

10 Excel Hacks Every Office Worker Can’t Live Without
10 Excel Hacks Every Office Worker Can’t Live Without
Must Know
Must Know
  • Navigate to your organization's SharePoint admin center.
  • In the left-hand navigation, click 'Show all' if necessary, then select 'Policies' and 'Site collections.'
  • Find the site collection that hosts your Excel file and click on it.
  • In the 'Access' section, click 'Users and groups.'
  • Find the user you want to delete, select the checkbox next to their name, and click 'Delete.'
  • Confirm the deletion by clicking 'Delete' in the pop-up dialog.

Using PowerShell

PowerShell is a powerful tool for automating tasks. Here's how to delete a user using it:

  • Open PowerShell as an administrator.
  • Connect to SharePoint Online using the following command: `Connect-SPOService -Url https://youroorganization-admin.sharepoint.com -UseAdminCredentials`
  • Run `Get-SPOUser -Site https://yourorganization.sharepoint.com -Name "John Doe" | Remove-SPOUser -Site https://yourorganization.sharepoint.com` (replace "John Doe" with the user you want to delete).

Removing a User from the Access List

This method simply removes a user's access to the Excel file without permanently deleting their presence from the file's history.

AD

To remove a user from the access list, follow these steps:

Using Excel's File Access Panel

This method works if you're using Excel Online or have the file stored in the cloud, like OneDrive or SharePoint.

  • Navigate to the Excel file in your cloud storage.
  • Click on the 'Share' button or the 'Share' link on the right-hand side of the screen.
  • Find the user you want to remove, click on their permissions, and select 'Stop sharing' or 'Remove user'.
  • Confirm the removal by clicking 'Remove' or 'Stop sharing' in the pop-up dialog.

Using Excel's 'File' Menu

If you're using a desktop version of Excel, you can remove a user from the file's access list using the 'File' menu:

AD
  • Open the Excel file and click on 'File' in the top-left corner.
  • Select 'Info' from the menu on the left, then click on 'Permissions'.
  • Find the user you want to remove, click on their name, then click 'Remove User'.
  • Confirm the removal by clicking 'OK' in the pop-up dialog.

And there you have it! You've successfully evicted a user from your Excel file. Remember, always ensure you're following your organization's data handling and privacy policies when removing users from files. Happy Excel-iting!

AD