Money in Excel: Subcategories Drop-Down to Show in Transactions Tab

Good morning,

I recently started using Money in Excel and I am having issues with the subcategories drop-down list on the transactions sheet populating from the categories sheet; even the excel preset subcategories don't show up as an option. Does anyone have a fix or work-around for this issue.