Trusted documents - Microsoft Support
Jan 24, 2022 · Making changes starts or disables the ability to create trust documents that protects your computer and your organization's network from possible malicious code in active content. Click the File tab. Click Options. Select Trust Center, and then Trust Center Settings. Click Trusted Documents.
View my privacy options in the Microsoft Office Trust Center
The options available in the Trust Center allow you to share documents with the people you want, as well as to find and remove hidden information you may not want to disclose. To learn more about Office privacy, read the Microsoft Privacy Statement.
Add, remove, or change a trusted location in Microsoft Office
You should use a trusted location to store a file when you don't want that file to be checked by the Trust Center, or if you don't want it to open in Protected View. Especially files with macros, data connections, or ActiveX controls (what we call active content).
Add, remove, or view a trusted publisher - Microsoft Support
In an Office application select File > Options. Select Trust Center > Trust Center Settings > Trusted Publishers. In the Trusted Publishers list, select the publisher to remove, and then click Remove. If the Remove button is greyed out, the Office program isn’t …
Sharing Office Scripts in Excel - Microsoft Support
Share and unshare your script in a workbook. You can use a script's Details page to share the script in a workbook. Your scripts are stored in your OneDrive. When you share one, you create a link to it in the workbook you have open. How to share a script from the Details page depends on your version of Excel.
I get a "stopped working" error when I start Office applications on …
Try guided support. You might get this error when you start the Office 2021, Office 2019, or Office 2016 versions of Excel, Word, Outlook, PowerPoint, Publisher, or Visio on your PC: Microsoft Excel has stopped working. Microsoft Word has stopped working.
Look up values with VLOOKUP, INDEX, or MATCH - Microsoft …
Here's an example of how to use VLOOKUP. =VLOOKUP (B2,C2:E7,3,TRUE) In this example, B2 is the first argument —an element of data that the function needs to work. For VLOOKUP, this first argument is the value that you want to find. This argument can be a cell reference, or a fixed value such as "smith" or 21,000.
Lock or unlock specific areas of a protected worksheet
Follow these steps: If the worksheet is protected, do the following: On the Review tab, select Unprotect Sheet (in the Protect group). Select Protect Sheet to change to Unprotect Sheet when a worksheet is protected. If prompted, enter the password to unprotect the worksheet.
Recover an earlier version of an Office file - Microsoft Support
Go to File > Info. Under Manage Workbook or Manage Presentation, select the file labeled (when I closed without saving). In the bar at the top of the file, select Restore to overwrite any previously saved versions. Tip: In Word, you can also compare …
More on data validation - Microsoft Support
To quickly remove data validation for a cell, select it, and then go to Data > Data Tools > Data Validation > Settings > Clear All. To find the cells on the worksheet that have data validation, on the Home tab, in the Editing group, click Find & Select , and then click Data Validation .
Open a document after a file corruption error - Microsoft Support
Open a document after a file corruption error. Excel for Microsoft 365 Word for Microsoft 365 More... Sometimes a file can be damaged in such a way that Word, Excel, or PowerPoint can't open it normally. But all is not lost. The Open and Repair …