I am trying to work out why when i save a BOM as an Excel file and try to edit the excel file alot of features in excel are greyed out? The feature of particular interest is 'subtotal'. 

If i copy the date from one sheet to another the issue goes away and i have access to all the features.