We are using the Sharepoint activities on a project, login mode is set to “Online” and given proper credentials.
Everything worked perfectly until we sign in on Excel with a different user than the one Sharepoint uses. Now every Sharepoint activity is giving me “Cannot contact web site ‘https://mycompany.sharepoint.com/’ or the web site does not support SharePoint Online credentials. The response status code is 'Unauthorized”. We have tried login out the Excel user and login with the Sharepoint user but nothing seems to work.
Any ideas? Thank you