User Profile
Lucy_Luo
Copper Contributor
Joined Sep 22, 2023
User Widgets
Recent Discussions
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 create a query using the same URL with no issue last time, but now I can't. The reason I can't - the organizational account option no longer appears for authentication. I can't connect using any other way. What should I do to make it appear again? I tried clearing cache of the excel and restarting my laptop.
