iterop

In C# using Interop i am loading an excel which contains macros for validations and dropdowns for some columns. I use my logic to update the cells and save the excel.But once the excel is saved the macros validations are getting disabled and validations are not performing and also the lookups...