The_Steward
Board Regular
- Joined
- Nov 26, 2020
- Messages
- 63
- Office Version
- 365
- Platform
- Windows
Hello
I am using a dependent searchable drop down data validation list in my excel sheet. But the list does not drop down immediately when the sheet is protected (Is usually delayed by up to a few minutes after I click on another cell and re-click the cell). Why is this happening and how do I fix this?
The formula I use for the dependent searchable drop down data validation list is not a macro but there is a macro connected with that cell so that it expands when selected.
I am using a dependent searchable drop down data validation list in my excel sheet. But the list does not drop down immediately when the sheet is protected (Is usually delayed by up to a few minutes after I click on another cell and re-click the cell). Why is this happening and how do I fix this?
The formula I use for the dependent searchable drop down data validation list is not a macro but there is a macro connected with that cell so that it expands when selected.