Manage data source settings and permissions (Power Query) - Microsoft …
Set stricter security. Set Excel Services authentication. See Also. Power Query for Excel Help. Authentication with a data source (docs.com) Microsoft 365 security center. Want more options? Power Query saves a data source credential, or sign in identity, for each data source connection you have used and data source privacy levels.
Refresh an external data connection in Excel - Microsoft Support
You can connect your Excel workbook to an external data source, such as a SQL Server database, an OLAP cube, or even another Excel workbook. This connection can appear in your workbook as a table, PivotTable report, or PivotChart. You can keep the data in your workbook up to date by refreshing the link to its source.
Best Practices for Coauthoring in Excel - Microsoft Support
Update your Excel installation frequently. We're always working to improve your coauthoring experience. By making sure you have the latest updates, you'll get access to the newest features and be less likely to encounter errors. Coauthoring works best when everyone can see changes made in real time.
Active content types in your files - Microsoft Support
This article lists types of active content that can be blocked by the settings in Trust Center and which, when present, will cause the display of a message bar upon opening the document. When active content is blocked, a Security Warning appears.
Why am I getting the message "Contacting the server for information ...
This occurs when Microsoft 365 is contacting a remote location, such as a file repository, an email server, a printer, or an Internet location. The message remains open the entire time Microsoft 365 is trying to contact the remote location. There are several scenarios where this message or a similar message is displayed. Connecting to printers.
Using wildcard characters in searches - Microsoft Support
Applies To. Use wildcard characters as comparison criteria for text filters and when you're searching and replacing content. These can also be used in the Conditional Formatting rules that use the "Format cells that contain specific text" criteria.
Personalized offers and discounts based on how you use Office
You can always choose to personalize your offers later if you change your mind. To find out how to view your privacy settings, see the Windows tab of the Account Privacy Settings page.