To update the password for an OData feed connection in Excel, you need to access the Data Source Settings and edit the credentials for the specific OData feed. This involves navigating to the Data tab, selecting "Get Data" (or "New Query" in older versions), then "Data Source Settings". From there, you can choose the relevant OData feed, edit its permissions, and update the username and password. [1, 2, 3]  

Here's a step-by-step guide: 
  1. Open the Excel workbook: Ensure your workbook containing the OData feed connection is open. [1, 4]  
  2. Access Data Source Settings: 
    • Go to the Data tab. [1, 2]  
    • Click on Get Data (or New Query in older versions). [1, 2]  
    • Select Data Source Settings. [1, 2]  
  3. Select and Edit the OData feed: 
    • In the Data Source Settings dialog, locate the specific OData feed URL you want to update. [1, 2]  
    • Click on the URL to highlight it, then click Edit Permissions. [2, 3]  
  4. Update the Credentials: 
    • In the Edit Permissions dialog, click the Edit button under the Credentials section. [1, 2]  
    • In the next dialog, enter the new username and password for the OData feed. [1, 2]  
    • Select the appropriate authentication method (e.g., Anonymous, Basic, Organizational account). [3]
      For Epicor, you must select the Basic section, and enter your Epicor username and password.  It will NOT be an email address, it wil usually be your FirstNameLastName as one string.
  5. Save and Close: 
    • Click Save to save the updated credentials. [1, 3]  
    • Click OK to close the Edit Permissions dialog. [1, 3]  
    • Click Close to close the Data Source Settings dialog. [1, 3]  

By following these steps, you can successfully update the password for your OData feed connection in Excel. [1, 2, 3]