5.2 Excel with Certificate

OData connection with certificate authentication.

• Certificate installed in Windows certificate store

1. Data → Get Data → From OData Feed
2. Enter URL: https://gateway.company.com/odata/erp
3. When prompted for certificate: Select your certificate
4. Connect

Windows shows a list of your certificates. Select the certificate with:

• Your name
• Issued by: „Company Internal CA“
• Valid until: Date in the future

Excel remembers the certificate assignment. For later refreshes, the correct certificate is automatically used.