Hello,
I have a big shared workbook with freeze panes and autofilters. When I Filter columns and then clear a filter or all filters, the freeze panes changes its location. So if the worksheet is frozen at G6, and I filter or unfilter something, the freeze changes to G7 or will lose the vertical freeze. Can someone tell me what causes this and how I can fix it? Thanks!
I have a big shared workbook with freeze panes and autofilters. When I Filter columns and then clear a filter or all filters, the freeze panes changes its location. So if the worksheet is frozen at G6, and I filter or unfilter something, the freeze changes to G7 or will lose the vertical freeze. Can someone tell me what causes this and how I can fix it? Thanks!
