Forum Discussion
Lucy_Luo
Sep 22, 2023Copper Contributor
Organizational account authentication disappeared when creating web query in Excel
Hi, I tried to create a query using web URL in excel (Get data -> From Web). The URL is an Excel macro-enabled workbook from our organization SharePoint, which I am the owner of. I used to be able to...
- Sep 22, 2023
Try to use the link without /:x:/r
For example, if that's Excel file - one which you find in File->Info->Copy path (without ?web=1 at the end)
SergeiBaklan
Sep 22, 2023MVP
Try to use the link without /:x:/r
For example, if that's Excel file - one which you find in File->Info->Copy path (without ?web=1 at the end)
Lucy_Luo
Sep 25, 2023Copper Contributor
Thank you Sergei! I removed the /:x:/r and it works now!
- SergeiBaklanSep 25, 2023MVP
Lucy_Luo , you are welcome