Tip: If you're a Microsoft 365 Family or Personal subscriber you get Microsoft Defender, our advanced security software for Windows, Mac, iOS, and Android, as part of your subscription.Learn more at Getting started with Microsoft Defender.

Published August 2021. This article is intended for users who are not able to upgrade to Windows 11 because their PC is not currently Secure Boot capable.

Note: For more info about the minimum system requirements for Windows 11, see Windows 11 specs, features, and computer requirements.

Approach. Formula. 1. Reference just the lookup values you are interested in. This style of formula will return a dynamic array, but does not work with Excel tables. =VLOOKUP(A2:A7,A:C,2,FALSE)2. Reference just the value on the same row, and then copy the formula down.

Right-click the app, select More, and then select Open file location.This opens the location where the shortcut to the app is saved. If there isn't an option for Open file location, it means the app can't run at startup.

Tips: If you don't see the OneDrive icon, OneDrive might not be running. On a PC, go to Start, type OneDrive in the search box, and then click OneDrive in the search results. You might need to click the Show hidden icons arrow next to the notification area to see the OneDrive icons. On a Mac, use Spotlight to search for OneDrive and open it.

If you work in a SharePoint in Microsoft 365 environment you have some powerful versioning tools at your fingertips. SharePoint in Microsoft 365 libraries offer version tracking, sharing, and recycle bin storage when you delete something. For more info on versioning in SharePoint in Microsoft 365, see:

Get in touch with Microsoft Support for assistance with Microsoft products and services.

You can use any phone number that can receive text messages; it doesn’t need to be associated with your account. We won't use or give out the phone number, and the code sent to it will expire after 10 minutes.

You have two options when syncing files in SharePoint libraries and Teams. You can either add shortcuts to libraries and folders to their OneDrive or use the Sync button in the document library.. Both options allow essentially the same thing—users can access files on their local computer in Explorer or Finder.