I have a Excel sheet and there is drop-down list which are connected another drop-down list. e.g. If I choose DEPT. in drop-down list, there is another drop-down to display all the DEPT. Name, If I choose DEPT. Name, there is another drop-down to display name of person whom working that dept. I would like to this excel sheet in track change mode. But when I applied track change, there is showing error, "Cannot copy or move array entered formulas or data tables in a shared workbook".
Please help.
If there is no support in track changes in Excel, any alternate solution which have track change (including drop-down list).
Thanking You,
Afzal
