Forum Discussion
Claire_FCT
Oct 12, 2022Copper Contributor
permissions for excel sheets on Teams which pulls data from password protected sheet...?
Hello there, I work for a small charity and we are trying to improve our data management but are facing a conundrum... Advisors (deal directly with service users) + Chairs (do not but need ...
Ed Woodrick
Oct 12, 2022Iron Contributor
What about using file level permissions
Claire_FCT
Oct 13, 2022Copper Contributor
Hi Ed,
I have tried this but the problem is that the Review worksheet shows the following error: 'UNABLE TO REFRESH - We couldn't get updated values from a linked workbook.' Presumably this is because the Chairs do not have permission to view the Advisor worksheets and so the data being pulled through is also considered not permissible to view?
I have tried this but the problem is that the Review worksheet shows the following error: 'UNABLE TO REFRESH - We couldn't get updated values from a linked workbook.' Presumably this is because the Chairs do not have permission to view the Advisor worksheets and so the data being pulled through is also considered not permissible to view?