Forum Discussion

Lucy_Luo's avatar
Lucy_Luo
Copper Contributor
Sep 22, 2023

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...
  • SergeiBaklan's avatar
    Sep 22, 2023

    Lucy_Luo 

    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)

     

Resources