Forum Discussion
Marcus_Booth
Jun 24, 2024Brass Contributor
Help with best practices for how to protect formulas on table and still expand with new records?
I have several tables, one on each worksheet, that need to be able to expand whenever a user types in a new record (formulas/drop-downs copied to new records). Apparently, Excel doesn't allow pro...
- Jun 24, 2024You could add a data validation rule to the formula cells. Set it to "Custom" and use this formula:
FALSE
That will disallow any entry to those cells. But pasting on top of them will still be possible.
JKPieterse
Jun 24, 2024Silver Contributor
You could add a data validation rule to the formula cells. Set it to "Custom" and use this formula:
FALSE
That will disallow any entry to those cells. But pasting on top of them will still be possible.
FALSE
That will disallow any entry to those cells. But pasting on top of them will still be possible.
Marcus_Booth
Jun 24, 2024Brass Contributor
This is certainly a step in the right direction. Unfortunately, it doesn't keep users from deleting the cell contents altogether. I put a not in the alt text field in data validation saying DO NOT DELETE CELL CONTENTS. Hopefully that will deter them from it. Thank you!