ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Freeze Panes bug when grouping columns and sharing a workbook (https://www.excelbanter.com/excel-discussion-misc-queries/220333-freeze-panes-bug-when-grouping-columns-sharing-workbook.html)

Aaron

Freeze Panes bug when grouping columns and sharing a workbook
 
I have Columns C:M grouped with colapse sign over column B. I freeze panes
at cell C8. At this point it works fine. But when I share the workbook,
close it and reopen it, as soon as I expand the grouping the frozen panes
shift as if I had frozen them at N8. How do I keep the panes frozen at C8?

Dave Peterson

Freeze Panes bug when grouping columns and sharing a workbook
 
Apply the freeze panes with all the rows and columns showing.

Then hide what you want.

Aaron wrote:

I have Columns C:M grouped with colapse sign over column B. I freeze panes
at cell C8. At this point it works fine. But when I share the workbook,
close it and reopen it, as soon as I expand the grouping the frozen panes
shift as if I had frozen them at N8. How do I keep the panes frozen at C8?


--

Dave Peterson


All times are GMT +1. The time now is 12:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com