Users somehow removing dropdowns

[llogan]

I have a sheet that I created for work that I'm having some problems with. First, here are some details about the sheet:

• Using Excel 2007
• It's password protected. Users are only able to select locked and unlocked cells, format rows and columns, and use autofilter.
• It contains several index match and vlookup formulas, and all those columns are locked.
• It contains dropdowns using data validation. These columns are not locked so the user is able to select from the dropdown.

The problem I'm having is that a sometimes when I receive the sheet back form a user, the dropdowns are gone. When the sheet is locked, data validation is not able to be selected, so I don't see how they could remove the dropdown. How is this possible?! This is causing issues since the dropdowns feed into the formulas, so with that data not there, other data is not able to be populated.

Any help would be appreciated. I should mention that since it is for my workplace, I cannot use any coding.

Thanks!

 

[Rhodie72]

I have a sheet that I created for work that I'm having some problems with. First, here are some details about the sheet:

• Using Excel 2007
• It's password protected. Users are only able to select locked and unlocked cells, format rows and columns, and use autofilter.
• It contains several index match and vlookup formulas, and all those columns are locked.
• It contains dropdowns using data validation. These columns are not locked so the user is able to select from the dropdown.

The problem I'm having is that a sometimes when I receive the sheet back form a user, the dropdowns are gone. When the sheet is locked, data validation is not able to be selected, so I don't see how they could remove the dropdown. How is this possible?! This is causing issues since the dropdowns feed into the formulas, so with that data not there, other data is not able to be populated.

Any help would be appreciated. I should mention that since it is for my workplace, I cannot use any coding.

Thanks!

have you allowed them to edit objects? If that is enable then that could be the cause.

 

[My Aswer Is This]

I first started learning about spreadsheets when users deleted things.
I was working in Maintenance control in the US Air Force.
I walked in one day and noticed a worker entering data into a spreadsheet and she also had a handheld calculator in her hand. I asked why she needed the handheld calculator and she said someone had deleted all the formulas and no one knew how to create new formulas. On that first day I took over the spreadsheets and turned into the office computer Geek.

 

[llogan]

have you allowed them to edit objects? If that is enable then that could be the cause.

Nope, they are not allowed to edit objects. They can only Select Locked Cells, Select Unlocked Cells, Format Columns, Format Rows, and use AutoFilter.