Forum Discussion
Freeze panes not working properly
I'm having an issue with freeze panes. I'm trying to freeze the first 2 columns and the top row of a large worksheet, so I'm using "Freeze top row" for the top row, and selecting the 3rd column and s...
I have had the same situation happen frequently and as yet haven't read a satisfactory explanation...
Whilst using the full downloaded client version of Excel 365 and particularly since ribbons came to fruition I have created customised ribbons, then this particular issue started occurring along with others...
My customised ribbon was made in a version a few years ago...is has been exported to later versions...then I found icons or functionality changed in some way or form. For example the Wrap Text and Group command buttons...
But whilst simply swapping out the old for the new solves those issues permanently, Freeze Pains remains unreliable, becoming disabled seemingly in random spreadsheet sessions...!
Currently the only way I have found is to remove the function from the ribbon and immediately add it back. This refreshes the ribbon and it is working again.
Whether this is a bug of the ribbon or of the code behind the function I do not know, but it remains a mystery...
So I do not tell you about instances where it is designed to be greyed out, purely my situation using Excel in everyday normal view mode.
It's a pain and I think an unresolved bug Microsoft has still to address.
Tink.
Whilst using the full downloaded client version of Excel 365 and particularly since ribbons came to fruition I have created customised ribbons, then this particular issue started occurring along with others...
My customised ribbon was made in a version a few years ago...is has been exported to later versions...then I found icons or functionality changed in some way or form. For example the Wrap Text and Group command buttons...
But whilst simply swapping out the old for the new solves those issues permanently, Freeze Pains remains unreliable, becoming disabled seemingly in random spreadsheet sessions...!
Currently the only way I have found is to remove the function from the ribbon and immediately add it back. This refreshes the ribbon and it is working again.
Whether this is a bug of the ribbon or of the code behind the function I do not know, but it remains a mystery...
So I do not tell you about instances where it is designed to be greyed out, purely my situation using Excel in everyday normal view mode.
It's a pain and I think an unresolved bug Microsoft has still to address.
Tink.