Are the dropdowns supposed to do anything? I cant seem to find any way of actually entering data or interacting with it in any way.
I'm completely ignorant in the ways of Excel, so If somebody could explain it to me like im 10 what'd be great.
I don't have access to the excel at the moment, but this is what should happen:
The file is opened.
At the top I first got a yellow bar, which asked me if I wanted to enable editing.
Then the next yellow bar showed up, as it was not a trusted document I also had to enable content.
After that I was able to use the drop down menu's. Make sure you start with the unit, before wargear, as it looks at the options beneath the unit for the wargear.
Also don't touch the grayed out fields, otherwise the references won't work
Hope this helps!