Forum Discussion
MarcusAD1979
Mar 09, 2021Copper Contributor
Excel Online Conditional Formatting - Unable to Edit Existing Rules
Hi, I have a file that was originally created in Excel Desktop. We are wishing to move the file to only online to prevent change/version errors. The conditional formats that were created on desk...
tekhnik
Aug 06, 2021Copper Contributor
winters80I can confirm identical behavior. Same file and same access permissions in SharePoint, but one user can create new rules, and edit existing, while other user can only delete. The first user is a global admin (like your site collection admin). The second user is the file's creator.
Did you ever figure out the reason? Anything with release schedule preferences?
SergeiBaklan
Aug 06, 2021Diamond Contributor
Does the person who can edit is in the list of targeted users?
- tekhnikAug 06, 2021Copper ContributorOur entire tenancy is on standard release, but I am enabling targeted to the non-edit user to see if they get the capability, in which case i will assume the edit-allowed user may have had targeted enabled in the past.