Ryan Clark

Can’t find why you can’t sort that column? In this short guide, I will explain why you can’t sort that person column and suggest what you should do instead. Let’s get started. Possible Reasons Why Columns Can’t Be Sorted The truth is that some columns in SharePoint can’t be sorted because of their data type or settings. For example: Person or group columns are a little tricky as they’re basically references to the user information list of your site collection. But that doesn’t mean they can’t be sorted. 🙂 👉 Related: Can’t Group by Column Category in SharePoint Online (Solved) […]

Feeling annoyed with the constant alerts about a ‘newer version’? In this guide, I will show you a few ways to remove your Excel workbook from the updates in SharePoint Online. Let’s get started. Removing Your Workbook If you think you’re the only one who gets annoyed with this “recommendation”: Well, you’re not alone. 🙂 Fortunately, it’s quite easy to remove your Excel workbook from the updates. 1. Save a Local Copy This method is the most common one used. You need to download your file first from the SharePoint document library: After saving it to your device, you can

Not seeing your column in the group by option? In this guide, I will explain the issue that you’re facing when trying to group by category column in SharePoint Online. Let’s get started. Possible Reasons for Grouping Issues No need to scratch your head anymore as the reasons are already known: 1. Incompatible column types The most common culprit here is the column types as some of them don’t support grouping, which can cause issues. Here are the columns that can’t be grouped: The simple solution here is to change the column or use another column to one that supports

Got some changes on who manages what? In this guide, I will walk you through changing the authorization for a list in SharePoint Online quite easily. Let’s get started. Changing Permissions for a List Fortunately, changing the permissions in a list is straightforward. Step 1: Access the permissions page The first step is to navigate to the list you want to manage. When you’re there, click the gear icon in the top-right corner and select the list settings option: This will bring you to a page where you can see various options related to your list. From here, select permissions

Want to separate your Excel file? In this guide, I will show you an easy way of separating your Excel workbook from SharePoint so it won’t receive updates. Let’s get started. What happens after disconnecting a workbook? Since you’re thinking about separating your workbook, it’s important to know what happens after you do that. 😅 Here’s what would happen: Well, the most obvious effect is that the workbook will no longer receive updates or reflect changes made on SharePoint. But make sure to track while file you’re working on to avoid consistences, and clear labeling offline copies would help. How

Can you link a word in a document to anywhere? In this guide, I will show you how to create a link from a word in SharePoint Online in few simple steps. Let’s get started! What is a hyperlink? You must’ve heard about hyperlinks already. Basically, they’re clickable elements that can direct users to another webpage or document, even outside SharePoint. Some common ways they’re used in SharePoint include: But mostly when inside SharePoint, they’re usually used to connect content and improve navigation. Hyperlinks make accessing other information easier simply from what a user is already reading within the page.

Want to save your Google Sheets? In this guide, I will show you some methods you can use to save your Google Sheets file to Sharepoint. Let’s get started. Does a straight method exist? Unfortunately, there isn’t a direct method out-of-the-box that will enable you to move Google Sheets to SharePoint. But some alternatives exist: While these work, there’s no fully seamless process for transferring a Google Sheets file to SharePoint Online in native format. There might be some automation tools that can help to some extent like Zapier, not sure about Power Automate yet. Method 1: Download and  upload

Want to link different words? In this guide, I will show you how to link two words on the same page in SharePoint Online quite easily. Let’s get started. Link Two Words on the Same SharePoint Page Okay, I’ve got a bad news and a good news. The bad news is, although you can technically link two “regular” words on the same page, it won’t anchor or scroll through. The good news is that if the destination word (or words) is a heading, it would work and anchor functionality is there. Step 1: View the SharePoint page Since this only

Got some guests whose access is expiring soon? In this guide, I will show you how to easily extend the SharePoint external user access for those nearing expiration. Let’s get started. What is the SharePoint guest expiration policy? The short of it is that this policy is designed to manage the access of external users who are invited to collaborate on content. Here’s how it works: However, the guest expiration policy doesn’t apply to users with permissions added before the policy was enabled. If a guest’s access expires, it can be extended (site admin) or set to never expire (depending