Dependent Drop Down using Data Validation not working after save and re-opening file

I created 3 dependent drop down lists, each dependent on the previous drop down list's selection using the OFFSET MATCH function in Data Validation. After I save, close the file, and re-open, the first dependent drop down works but the 2nd and 3rd dependent drop down lists no longer work. I have to go back into Data Validation and click OK for each cell the drop down list is in. I have saved the file in a .xlsm format and used names for columns. Is there a macro that I can run for it to automatically re-fresh the Data Validations in each cell upon opening the file?

Hi,

I have the exact same problem as described by Laxb14....
The first drop-down list have no issue and I am able to choose from the list, the second one, which is dependent on the first one, is also working and I am able to choose from the list depending on the first choice, but when I get to the third drop-down list, I am able to see the in-cell arrow, but nothing happens... I need to go to the data tab, open data validation, (the formula is still there for the cell(s) ), click ok and it activates the drop down list and I am able to make a choice of the list, depending on the previous two choices...
This happens in both, Excel 2013 and Excel 2016, the file is saved as *.xlsm. I also deleted all macros I had, saved it as *.xlsx, unfreeze all panes, unlocked all cells in the second worksheet where all data is placed. Unprotected all worksheets... and again I save the file, close it, reopen it and the same problem with the third drop down list appears...!

This are the formulas that I am using for the dependent drop down lists

Data Validation formula in the second drop-down column: =OFFSET(Data!$W$2;MATCH($F7;INDIRECT(Table1[FirstColumn]);0);1;COUNTIF(INDIRECT(Table1[FirstColumn]);$F7);1)
Data Validation formula in the third drop-down column that is actually not working after reopening the document: =OFFSET(Data!$Z$2;MATCH(1;(INDIRECT(Table2[FirstColumn])=$F7)*(INDIRECT(Table2[SecondColumn])=$G7);0);2;COUNTIFS(INDIRECT(Table2[FirstColumn]);$F7;INDIRECT(Table2[SecondColumn]);$G7);1)



Did you already find any solution?
I would be really grateful if someone is able to share it

Thanks in advance