A #CONNECT error occurs when a formula can't connect to a required resource. See the following: General

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.

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

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.

Dans Excel, vous pouvez vous connecter aux cubes OLAP (souvent appelés cubes multidimensionnels) et créer des pages de rapports intéressantes et attrayantes avec Power View.

You can use Microsoft Office Excel to create and edit connections to external data sources that are stored in a workbook or in a connection file. By using the Workbook Connections dialog box, you can easily manage these connections, including creating, editing, and deleting them.

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.

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.

Use the Microsoft 365 setup troubleshooter to install Microsoft 365, Office 2021, Office 2019, or Office 2016 on your Windows PC. Select the button below to start the setup troubleshooter.

Obtenir de l’aide contient des utilitaires de résolution des problèmes pour Microsoft 365 que vous pouvez exécuter pour de nombreux scénarios courants. Ils permettent souvent de résoudre les problèmes sans avoir à contacter le support technique.