leatherhen99
New Member
- Joined
- Dec 17, 2019
- Messages
- 27
- Office Version
- 365
- Platform
- Windows
Good Day All!
I can't seem to find a canned answer for this...and there might not be one... I have a table with business exceptions with about 10 columns... on another sheet, I have a complex index/match formula with multiple combinations based on start/end dates and the agent's name based on the exceptions. The range within the formula can change often, so I'm using the table fields within the formula (you see where I'm going, don't you?). Yesterday, the team who uses the spreadsheet said that the exceptions were not populating, so I had to go investigate. Someone had changed the range of the table... they had made it 8 columns instead of 10
... removing the very two columns that my formulas were supposed to be returning.
So, I know how to lock/protect a cell, range, sheet, and workbook... but now, I need to be able to protect the structure of my table (10 columns wide), and allow the user to continue to make edits as necessary. I've read about protecting the workbook, but I only see that it protects them from adding/deleting/moving a page... that won't protect the integrity of my table, will it?
Any suggestions you have would be greatly appreciated!
Have a great Tuesday!
I can't seem to find a canned answer for this...and there might not be one... I have a table with business exceptions with about 10 columns... on another sheet, I have a complex index/match formula with multiple combinations based on start/end dates and the agent's name based on the exceptions. The range within the formula can change often, so I'm using the table fields within the formula (you see where I'm going, don't you?). Yesterday, the team who uses the spreadsheet said that the exceptions were not populating, so I had to go investigate. Someone had changed the range of the table... they had made it 8 columns instead of 10
... removing the very two columns that my formulas were supposed to be returning. So, I know how to lock/protect a cell, range, sheet, and workbook... but now, I need to be able to protect the structure of my table (10 columns wide), and allow the user to continue to make edits as necessary. I've read about protecting the workbook, but I only see that it protects them from adding/deleting/moving a page... that won't protect the integrity of my table, will it?
Any suggestions you have would be greatly appreciated!
Have a great Tuesday!
