I have a file that uses data from external sources. I currently have it running on pivot table. The rows will always change from month to month so using grouping would take a long time since there are over 2000 rows.

With pivot table reports there is a function to expand and collapse fields. Is there a way to use a similar function without a pivot table?

Thanks

Fawn