1. In Microsoft Excel when configuring the oData connection string, use the Advanced button to change Integrated Security to "Basic"
  2. Enter your Blackbaud CRM user name and password
  3. Click OK.