Note: If you choose a connection from the Connections in this Workbook category, you will be reusing or sharing an existing connection. If you choose a connection from the Connection files on the network or Connection files on this computer category, the connection file is copied into the workbook as a new workbook connection, and then used as the new connection for the PivotTable report.

Important: Workbook links are considered potentially unsafe and must be enabled when you open a formula workbook.When you open a formula workbook, click Enable Content in the Message Bar to allow the workbook links to function. If you don't, Excel keeps the most recent values and disables refreshing the links with values from the data workbook.

2. Record Validation Rule You can use a record validation rule to specify a condition that all valid records must satisfy.You can compare values across different fields using a record validation rule. For example, a record with two date fields might require that values of one field always precede values of the other field (e.g., StartDate is before EndDate).

In addition to the File menu, you can turn this feature on or off right from the context menu of a One Drive or SharePoint-hosted Word, Excel, or PowerPoint document URL appearing in a Word, Excel, PowerPoint, or Outlook Windows application. The context menu also allows you to choose a one-time file open behavior for a specific link by using the Open With menu option.

Manually download a language for Cortana speech. Go back to Settings > Time & language > Language, select your new language, and then use the up-arrow button to move it to the top of the list and make it the default.

Here’s how to reinstall Microsoft Edge whether you’re a Windows or Mac user: Open any working browser. (Note: If you’re a Windows user and your Microsoft Edge is not currently functioning, to open Internet Explorer, type IE in the search box on the taskbar and then select Internet Explorer from the results.Or press the Windows logo key on your keyboard and then type IE in the search bar.)

Solucionar problemas con accesorios Bluetooth. Si puedes activar Bluetooth pero tienes problemas para emparejar o usar un accesorio Bluetooth, prueba los siguientes pasos para solucionar problemas comunes de accesorios Bluetooth.

Default Office theme colors. The color palette of the Office theme prioritizes the creation of modern and accessible content. The previous Office theme has been renamed Office Theme 2013–2022 and can still be accessed in the theme galleries of each Office application.. Change a theme and make it the default in Word or Excel

Learn how to download, install, and configure Language Accessory Packs for Microsoft 365 for additional display, help, and proofing tools.

IMPORTANT This update is not needed and will not be offered if your Windows Recovery Environment (WinRE) meets any of the following conditions: If the WinRE recovery partition does not have sufficient free space.