Insert Illustrations Buttons Greyed Out in Excel

File > Options > Advanced > Display Options for This Workbook

Ensure the For Objects, Show: option is set to All  
Insert Illustrations Buttons Greyed Out in Excel