Forum Discussion
Group Function - not working
I stumbled upon a discovery as I was having the same issue even when having the settings checked to show the outline "ticks" (the "+" and "-" outline toggles). It really is working but if your situation is like mine there are two related things happening.
1) In the outline settings you have unchecked the settings for the outline direction so that your summaries are above the detail and to the left of the detail (opposite of the default setting), and
2) you are trying to include row 1 and/or column A in your group.
The solution if you want to keep your preferred direction settings (have your summary at the top of the group etc) is to insert a blank row 1 and/or blank column A. Excel seems to require this space to display the "ticks". Hope this helps you and future frustrated users. Happy to be able to contribute a solution for once...
As an aside if there are any Microsoft engineers monitoring this site I really wish you would provide a setting option to allow this direction configuration to be the default as it makes way more sense in my application of the outline feature. I have to change it every time and its annoying.