ODATA Unauthorized Connection Error

In the video, a solution to the unauthorized connection error when connecting to the BUCS Odata feed in Excel is explained. The error occurs when Excel retains your historical password, preventing the entry of new authentication details for a different company. If you encounter this issue, cancel the connection attempt and navigate to the Data tab. Select "Get Data," then go to "Data Sources," and clear the permissions for the historical Odata connection by pressing delete.

After clearing the old permissions, close the data sources window and attempt to connect to the Odata feed again by entering the new URL. This action will prompt you to enter your basic authentication details, allowing you to reconnect to a new data source from another company. This process resolves the connection error, enabling seamless data integration across multiple companies in Excel.