Grouping/Sorting in Excel - Sub-groups not sorting with grouped row

[OliverBP]

I'm having some issues with grouping and sorting those groups in Excel. Hoping someone can help.

Picture of the excel I'm using here: http://i.imgur.com/XX0uput.png

Each green coloured row is supposed to be a subcategory of the white coloured row above it. When I group rows 8-10 with Row 7 and then sort by the Fund Manager column, rows 8-10 remain where they are and row 7 sorts alphabetically. This applies for all the groupings I've used in the sheet.

Further step-by-step examples of what I mean:

Grouping: http://i.imgur.com/ImZUdkC.png

Sorted alphabetically, the grouped data remains in rows 8-10, rather than following the data that was originally in Row 7: http://i.imgur.com/vUU5x4l.png

Help would be appreciated, this is driving me insane as it used to work

 

[OliverBP]

Bumping this thread

 

[OliverBP]

Bumping

 

[OliverBP]

Bump

 

[OliverBP]

Hopeful bump

 

[RoryA]

Please don't bump your thread that often - no more than once a day. You actually make it less likely that the thread will be seen as many members look at threads with no replies first.

 

[OliverBP]

Daily bump

 

[RoryA]

Try grouping all the groups that need to stay together, then collapse the groups and sort.

 

[OliverBP]

I have been doing that and some groups move with the assigned groups and some don't. The majority of the time the grouped/collapsed rows remain where they are post-sort and the heading grouped row sorts.

Really strange as there seems to be no difference between the cells that sort properly and those that don't.

 

[RoryA]

Can you put a workbook somewhere (OneDrive / Dropbox / whatever) with any confidential data removed so I can have a look at it?