Forum Discussion
matt0020190
Jun 07, 2024Brass Contributor
Accessing Web Content - Consistent Login Requests
Hi all Hope you are well and can maybe understand this one. In my workplace, I have a master spreadsheet that needs to be "queried" from another spreadsheet. The way I gone about this is usi...
- Jun 15, 2024
Depend on link you use to access the file. If we are speaking about Excel file on SharePoint you may open it, File->Info->copy path and use it removing ?web=1 at the end.
Alternatively you may copy the path from the bottom of Details pain in SharePoint.
In any case URL taken from browser with
inside won't work.
matt0020190
Jun 14, 2024Brass Contributor
Anyone able to advise?
SergeiBaklan
Jun 15, 2024Diamond Contributor
Depend on link you use to access the file. If we are speaking about Excel file on SharePoint you may open it, File->Info->copy path and use it removing ?web=1 at the end.
Alternatively you may copy the path from the bottom of Details pain in SharePoint.
In any case URL taken from browser with
inside won't work.
- matt0020190Jun 19, 2024Brass ContributorHi Sergei, this appears to have worked. I followed your steps and the :x/r in the new links is removed. Seems to ask for credentials and then goes away now. Will report back if it returns. Thank you!