I was having issue and had to "turn on" add-ins for the workbook that I was using as it was created by a company that provides template workbooks (accounting/audit)