Sep 08 2022 07:58 AM
Hello,
I understand that in order to protect cells and formulas from being overwritten that I need to change the settings on the desktop version of Excel. However, when I do apply these settings and then upload the file to OneDrive to be used in Excel Online (for collaboration), I run into problems.
Basically, users cannot enter information in any fields, regardless of whether those cells were protected or not. Is there a security option I am missing? Do I need to change something in the online version as well? I am tired of people overwriting my formulas and breaking the workbooks.
Any help would be greatly appreciated!
Sep 09 2022 07:33 AM
@mkhernandez79 I know dealing with protection is a newer feature in online excel and don't know how well it 'plays' with desktop settings. Maybe just set the protection online:
as you can see you can add ranges to allow editing.
Sep 09 2022 08:54 AM
Hi @mtarler, thank you for your help! I actually found that it would work but unfortunately, once I enact protection, it no longer allows auto-fill of a new row in a table. I know I can leave access open to add a row, but I have trouble getting people to sort by headers, let alone use the "Insert Row" command...Any way around that particular issue? Thanks again!!
Sep 09 2022 09:13 AM