From the Excel Add-in, you can choose one of three endpoints - Production, TIP1, or Direct Connect.
For practical purposes, Production is the endpoint that works for me.
Out of curiosity, can someone explain what a CDS Endpoint is, and the purpose of the TIP1 and Direct Connect endpoints?

Thanks!