Forum Discussion
Group/ungroup protected functionality issues with Excel 2019 in Windows 2019 server
We have users who are accessing some Excel files which has formulas with macros. When the excel file is opened locally from desktops with Office 365, the group/ungroup functionalities are not protect...
Hi kpr208
all I can say is that there is indeed a different behaviour between Excel 2019 (or older) and Excel from Office 365/M365, as far as grouping in protected sheets is concerned.
In O365/M365 you can show/hide grouped columns even on protected sheets, if this option has been set during protection:
Unfortunately, this dos not work in Excel versions before O365/M365.
So, it's a new feature that does not exist in Excel 2019 and unfortunately, you cannot do anything about it.
