At this point you may experience unwanted prompts to enable macros, update workbook links, or refresh data connections within workbooks that you use frequently. You can suppress these prompts on a case by case basis, as shown in Figure 6.
- Do not click the Enable Content button when a message bar prompt concerning macros, workbook links, or data connections appears.
- Instead click Excel’s File menu.
- Select the Info tab that will contain a second Enable Content prompt.
- Click on Enable Content.
- Choose Enable All Content from the Enable Content prompt. In most cases this command will parenthetically say “Make this a trusted document.”
Once you mark a document as trusted then you will no longer encounter message bar prompts, which means you can freely use macros as well as have workbook links and data connections update automatically. In this fashion you can efficiently open frequently used documents while still encountering protective prompts as you open unfamiliar documents. In fact, you always have the option to purposefully open a document in Protected View, as shown in Figure 7:
- Press Ctrl+O to launch Excel’s Open dialog box or use the File menu to navigate manually to the Open dialog box.
- Click once on the name of a document.
- Click the arrow on the right-hand side of the Open button.
- Choose Open in Protected View.