The edit options are greyed out on my report
When saving reports from Sims .net the edit options such as Data sort are greyed out – this is in Excel 2010.
If the header bar, besides giving the file name, also says Group:-
1. Right click on the ‘Sheet 1’ tab at the bottom
2. Choose Ungroup
KB6568
Reviewed 29/04/2015