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