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. Each time you refresh the connection, you see the most recent data, including ...

Learn how to fix problems signing into your Microsoft account. Resolve password verification, locked account, and other Microsoft account login issues.

Tip For Word, Excel, and PowerPoint desktops, select the lower half of the Check Accessibility button for more options. In the Accessibility pane, review and address the findings under Inspection Results. Apply recommended actions In the Accessibility pane, you'll see a list of errors and warnings, with how-to-fix recommendations for each.

You can use an Office Data Connection (.odc) file to connect to an Online Analytical Processing (OLAP) database. On the Data tab, select Get Data > From Database > From Analysis Services. Note: If you are using Excel 2013, 2010, or 2007, on the Data tab, in the Get External Data group, select From Other Sources > From Analysis Services.

Get support, help, and learning resources for Microsoft 365. Organize your life, expand your creativity, and protect what’s important with Microsoft 365.

Here are some things you can try to fix the problem. We've listed the most common solutions first, so try them in order. Restart your device Wait a few minutes, restart your device, sign back in, and restart your app. Repair Office or Microsoft 365 from the Control Panel How you get to the repair tool depends on your operating system.

How to correct a #SPILL error in Excel (when a formula returns multiple results and cannot return them to the grid).

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.

After you have created a connection to an external data source in Power Pivot, you can later change the connection information, table and column mappings, and which tables, views, or columns you get from the external data source.

Repair broken Office app installations. If a Microsoft 365 application such as Word or Excel isn't working correctly, sometimes restarting it will fix the problem. If that doesn't work, you can try repairing it. When you're done, you might need to restart your computer.