Accesing data from a cell in another SharePoint Group

Occasional Contributor

Hello everyone.

 

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.

0 Replies