How to Share Excel File for Multiple Users (Two Methods)

How to Share Excel Files with Multiple Users (Two Methods)

Table of Contents:Method 1: Coauthoring Excel File With Other UsersStep 1: Upload the Excel File to OneDriveStep 2: Share the File with OthersMethod 2: Sharing Excel File With Tracked ChangesStep 1: Customize Quick Access ToolbarStep 2: Change Property OptionsStep 3: Track ChangesStep 4: Share WorkbookStep 5: Protect SharingStep 6: Send the File to Others Can you share an Excel sheet with others? You want to share your Excel file with others, allow them to work on it, and make changes. Unless you’re a power user, collaborating with others with Excel may seem a bit tricky. This is a corner where […]

How to Share Excel Files with Multiple Users (Two Methods) Read More »

Create and Deploy a Custom Theme for SharePoint Modern Site

Create and Deploy a Custom Theme for SharePoint Modern Site

Table of Contents:How to Create a SharePoint Theme With the Theme Generator ToolHow to Use PowerShell to Install a Custom ThemeSelect the New Theme on the SharePoint Site You feel limited by the number of default themes that SharePoint offers. Yes, they may be attractive (built-in) themes, but that’s all there is to it. You’re stuck with what’s available to you. Fortunately, you can now create your own custom theme with the help of the theme generator tool and install it on your site. The question now is, how do you use the tool? What to do then? How do

Create and Deploy a Custom Theme for SharePoint Modern Site Read More »

How to Fix “Cannot Send This Item” in Microsoft Outlook

How to Fix “Cannot Send This Item” in Microsoft Outlook

Table of Contents:Change the Email Format to Rich TextUse the Outlook Web App (OWA)Change the Microsoft 365 Apps Update ChannelRemove the Long Links Outlook users have been reporting an issue on various online communities regarding a “Cannot send this item” error that they encounter. Although Microsoft has supposedly released a fix for this last April 2021, you may be one of those users who still experience this issue. The “Cannot send this item” error in Microsoft Outlook started showing up for users on long email threads and when replying or forwarding emails with embedded hyperlinks point to website pages with

How to Fix “Cannot Send This Item” in Microsoft Outlook Read More »

How to Set Up a Mail Flow Rule for External Email Messages

How to Set Up a Mail Flow Rule for External Email Messages

Table of Contents:How to Set Up a Mail Flow Rule for Non-Organization AddressesStep 1: Create a Rule in Exchange Admin CenterStep 2: Name the RuleStep 3: Specify What the Rule Will DoStep 4: Prepend a DisclaimerStep 5: Enter the Code You’re trying to set up a mail flow rule that will include a disclaimer to help protect members of your organization against harmful elements from external email messages from non-organization addresses. Unfortunately, after setting up a rule, putting up a nice code to make the disclaimer pop out, you find out that the rule doesn’t work. Even the colors you

How to Set Up a Mail Flow Rule for External Email Messages Read More »

How to Create a Team in Microsoft Teams [Quick Tutorial]

How to Create a Team in Microsoft Teams [Quick Tutorial]

Table of Contents:How to Create a Team in Microsoft TeamsHow to Manage Your Team in Microsoft TeamsHow to Add a Channel to Your Team So you just finished installing Microsoft Teams and you now want to create a team so you can communicate with your members. The thing is, those who are more adept at technology and using various software and platforms may not have any problems with this. Understandably, this will seem like rocket science to others who are not as adept. In this article, you’ll learn how to easily create a team in Microsoft, step by step, and

How to Create a Team in Microsoft Teams [Quick Tutorial] Read More »

Illustration of a yellow unlocked padlock, a document with a blue locked padlock, and a yellow key on a blue background, symbolizing security and access control.

How to Unlock a File in SharePoint Online: Fix Ghost Locks Fast

Table of Contents:File Locks in SharePoint OnlineWhat Does a “Locked File” Actually Mean?Exclusive Lock: The Check-Out MechanismCo-authoring Lock: Real-Time CollaborationApplication “Ghost” Lock: The Real TroublemakerSelf-Service Solutions (For End-Users and File Owners)Method 1: The 10-Minute Wait (Ghost Locks Only)Method 2: Discard Check-Out (If You Checked It Out)Method 3: Clear Your Office Document Cache (Recurring Lock Issues)Method 4: The Check-Out and Check-In Cycle (Teams and SharePoint)Administrator and Site Owner SolutionsDo You Have Permission to Unlock?Method 1: Force Check-In (Save User Changes)Method 2: Force Discard Check-Out (Revert Changes)Method 3: The OneDrive Workaround (Stubborn Ghost Locks)Advanced PowerShell Solutions (For IT Teams)Setup: Installing and Connecting

How to Unlock a File in SharePoint Online: Fix Ghost Locks Fast Read More »

How to Enable External Control in Microsoft Teams [Desktop Control]

How to Enable External Control in Microsoft Teams [Desktop Control]

Table of Contents:How to Allow External Participant to Give/Request ControlStep 1: Access the Meeting PoliciesStep 2: Enable the External Control FeatureSecurity Concerns One of the most often asked questions in regards to team collaboration in Microsoft Teams is how to enable external control of the desktop. This is such a pain especially for people who are miles apart and work together online. Fortunately, this is an easy fix, which you will learn in this article. Let’s start! How to Allow External Participant to Give/Request Control The first thing you need to know is that this feature is disabled by default

How to Enable External Control in Microsoft Teams [Desktop Control] Read More »

How to Create Column and List Validation in SharePoint

How to Create Column and List Validation in SharePoint

Table of Contents:What is column validation in SharePoint?How to create column validation in SharePoint?How does list validation differ from column validation?How do you create a list validation rule in SharePoint?Limitations of Column and List Validation The ability for your users to add metadata to the documents and files in a list or library is truly beneficial. With the use of other features like lookup columns and search filters, you’ll be able to find things a lot faster. Unfortunately, there’s only so much you can do to ensure that they enter the correct information. On the bright side, you can at

How to Create Column and List Validation in SharePoint Read More »

How to Enable the Spell Check in Microsoft Teams

How to Enable Spell Check in Microsoft Teams Easily

Table of Contents:Is there a spell check on Microsoft Teams?How to activate the spell check in Microsoft Teams?Why is your Microsoft Teams Spell Checker not working correctly?Does Grammarly work with Teams? Spell check is one of the most requested features in Microsoft Teams. Unfortunately, a lot of users either find that their Teams don’t have any sort of spell check or worse, their spell check is not functioning correctly. Do you belong to any of those groups? In this article, let’s discuss the spell check feature in Microsoft Teams and show you how to activate it. Meanwhile, I will also

How to Enable Spell Check in Microsoft Teams Easily Read More »

SharePoint Lookup Column: How to Create One Easily

SharePoint Lookup Column: How to Create One Easily

Table of Contents:What is a lookup column?How to create a lookup column?Step 1: Add a Lookup ColumnStep 2: Configure the Lookup ColumnStep 3: Edit the MetadataLimitations of a Lookup ColumnAlternatives to a Lookup ColumnUsing the SharePoint Lookup Column If you have plenty of lists and libraries on one of your sites, then you may have wondered at some point if there was a way for you to show some columns from one list or library to another. With a lookup column, that’s certainly possible. In this article, I’ll show you how to easily create one on your SharePoint site. Note

SharePoint Lookup Column: How to Create One Easily Read More »

Scroll to Top