Forum Discussion
Access Excel spreadsheets in secure SharePoint site
I am trying to connect to Excel spreadsheets in a company secure SharePoint site. I currently connect through my local copy, updated through OneDrive. However, I want to do automatic updates and not update locally and republish each time.
I try to connect through Web, give it the url, and it wants authentication. If I use my personal authentication, I will have to update it every time my password changes.
Looking for permanent options.
Thank you!
1 Reply
- lbendlin
Super User
" If I use my personal authentication, I will have to update it every time my password changes."
That's as good as it gets unless your company supports OAUTH. Even then the authentication can expire and may need to be renewed.
