So I've programmed using Excel Interop before, but I can't figure out something.

I have a spreadsheet with thousands of material properties listed in them. In the excel spreadsheet if I change that enum I can recalculate the sheet retrieving the values I need.

I want to form a repository of info so I can retrieve it for another program I'm planning, but I don't know how to change that enum programmatically.

Included a pic of the spreadsheet the enum is the one that says Benzene if that helps at all.

So, you need to change the selection of a dropdown list ao the sheet will recalculate?
Wondering: if you had a VBA macro that could do that, could you call the macro from C#, then pick-up the values from the sheet?