Grouped Cells

[kyle_04]

Hi all,

Got a bit of issue with grouped cells,

When a filter is on the figures disappear when the grouped cells are closed, but they don't when the filter is off.

Also, I have found when you put a filter on and try to close a set of grouped cells the whole sheet appears again, and if I close them before hand then put the filter on they appear open.

has anybody else noticed this?

Regards,

Kyle

 

[kyle_04]

Any ideas?

The grouped cells obviously contain the figures and the cell showing is the total (Which is a formula). No matter what formula is used the figures still display as zero (With a filter on, and the grouped cells closed).

There must be a way round this.


Kyle