All,

I frequently encounter situations whereby if I am operating a filter on a
particular column in excel it also collapses rows (such as subtotals etc)
that need to remain visible. I recall seeing a mechanism wher you can 'clear'
this issue? Has anyone encountered this issue, and what is the resolution?

many thx,

Don-