ODATA Refresh Error with Excel 2013 from a CRM Query

When a user attempts to refresh ODATA inside of Excel 2013 they may receive a error message such as "the remote server returned an error: (401) Unauthorized"
If the user is a non-admin user ensure that the feature permissions under Query--System Privileges-- Allow access to all query views and Run queries as a admin are granted.  Attempt to refresh the data after those permissions have been added to the current role. 

Steps to Duplicate

1.  Open a excel file that has ODATA associated with it
2.  Attempt to refresh data
3.  See issue

Environment

 Blackbaud CRM
 4.0
 4.0.157.0

Was this article helpful?