Nov 12 2021
We are moving some shared folders to SharePoint Online, every area is getting its SharePoint group.
Team A has an Excel file with Company Budget data in its group. Access is limited to a few users.
Team B needs to query data in a cell in the Excel file in Team A group but not every member of Team B has access to Team A group. So update queries fails.
Is it possible to create a query that uses a proxy like connection with auth data of a user with access permissions to Team A files?
Hope you get the idea. Thanks in advance.