"I am creating an app that simply displays specific data from an Excel table. The data in the table is not edited through the app. I've connected the Excel table using the 'Connector > Excel Online.' I've shared this app within my team, aiming for each team member to only see their own data. However, I don't want them to access the original data source, so I've hidden the sheet and shared the Excel file with 'view-only, no download' permissions.
However, team members are encountering an error when attempting to retrieve data from the network: 'An error occurred while retrieving data from the network: The user doesn't have permission to open the workbook in edit mode. Please correct the permissions and try again.' Is there a solution other than granting edit permissions?"