In the Data Connection Wizard, type the server name where the cube is hosted, then select and provide the appropriate credentials. Excel presents a dialog that lists the databases, tables, and cubes that are available from the server.

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.

This article discusses troubleshooting steps that can help resolve the most common issues when you receive an Excel not responding error, Excel hangs or freezes when you launch it, or open an Excel workbook.

Check the internet connection on your device and try again. For more information, see Fix network connection issues in Windows. There are calculations that depend on data types from data domains defined by one or more Office Add-ins. Try closing and reopening the workbook to get the add-ins to load.

Diagnose an error message about connections to external data. Redirect a connection to a different server or data source, or replace the connection file for an existing connection.

To refresh a workbook, press Ctrl + Alt + F5. 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.

Découvrez comment utiliser un fichier de connexion de données Office pour vous connecter à une base de données OLAP.

Use the Microsoft 365 network connectivity test to measure connectivity between your device and the internet, and from there to Microsoft’s network. View troubleshooter results. After you run any troubleshooter, Get Help provides details on any findings and suggestions for possible remedies.

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.

Running Microsoft 365 or Office as administrator helps fix permission issues that might cause Microsoft 365 or Office activation to fail. Follow the steps below for your operating system.