![]() ![]() Will this solution be in fact secure, meaning will my colleagues be prevented from somehow accessing the PowerQuery and removing the filter thus seeing rows that are "not theirs"?ģ. Does it seem like a reasonable solution, or am I overthinking this and is there a simpler method? (just for context, in parallel I'm exploring Power BI with RLS solution, but colleagues are more comfortable with Excel for now, so I have to at least try this).Ģ. Office 365 combines the familiar Microsoft Office desktop suite with cloud-based versions of Microsoft's next-generation communications and collaboration servicesincluding Microsoft Exchange Online, Microsoft SharePoint Online, Office for the web, and Microsoft Skype for Business Onlineto help users be productive from virtually anywhere throug. I know there's no way to let people see only part of a workbook, so I'm thinking of a workaround: I would create one additional child Excel file for each colleague, in these child files create a Power Query which would connect to the master file and filter the data by column A, and then share these child files with read only permissions with colleagues.ġ. Column A identifies who should be able to see what. This file contains many rows of data, and I want to grant each colleague a way to see some, but not all rows. I have an Excel master file saved in a SharePoint site. ![]() Me and colleagues have Office 365 E3 licences. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |