View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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