Search results
Results From The WOW.Com Content Network
Power Query saves a data source credential, or sign in identity, for each data source connection you have used and data source privacy levels. You can manage these settings, for example, to change your password.
Add a password to protect worksheets or your entire workbook and control whether others can open or make changes to them.
To fix this, click View > Window > Unfreeze Panes. If you scroll down your worksheet but always see the same top rows, they're locked in place (frozen). Use the Unfreeze Panes command to unlock those rows.
In Excel, you can change the macro security settings to control which macros run and under what circumstances when you open a workbook. For example, you might allow macros to run based on whether they are digitally signed by a trusted developer.
After installing the April 2021 security update to Microsoft Office, some automation add-ins for Excel may not load and you could see a “ Cannot run the macro ” error message. STATUS: WORKAROUND. To work around this issue, you will need to make a change in the registry. Important: The following steps show you how to modify the registry.
You can manage your queries either in the Queries pane of the Power Query Editor or on the Queries tab of the Queries & Connections pane in Excel. This is especially helpful if you have many queries and you want to quickly locate a query.
To prevent changes to your drop-down list data, you can hide the columns, rows, or the entire worksheet that contains the data. And unhide them if you need to make changes. You can also lock and password protect the cells on the worksheet or even the entire worksheet. Lock cells to protect them
Enable or disable security alerts on the Message Bar. Applies To. The Message Bar displays security alerts when there is potentially unsafe active content (such as macros, ActiveX controls, data connections and so on) in the file that you want to open.
If you're using the Inquire features to analyze or compare workbooks that are password protected, you'll need to add the workbook password to your password list so that Inquire can open the saved copy of your workbook.
Check an Excel workbook for compatibility with earlier versions of Excel. To make sure that an Excel 2007 or later workbook does not have compatibility issues that cause a significant loss of functionality or a minor loss of fidelity in an earlier version of Excel, you can run the Compatibility Checker.
If you’re new to Excel 2013, this free guide offers useful tips to help you find your way around. Need a guide for a different Office product? Download other Office 2013 Quick Start Guides.