Excel issue

%3CLINGO-SUB%20id%3D%22lingo-sub-1167388%22%20slang%3D%22en-US%22%3EExcel%20issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1167388%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20using%20Office%20365%2C%20have%20my%20spreadsheets%20on%20OneDrive.%20I%20keep%20hitting%20on%20this%20issue%20where%20all%20of%20a%20sudden%2C%20when%20working%20on%20a%20spreadsheet%2C%20freeze%20panes%20will%20be%20grayed%20out.%20Usually%2C%20I%20can%20save%20my%20file%2C%20reopen%20it%2C%20and%20freeze%20panes%20is%20available%20again.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CU%3E%3CSTRONG%3EI%20do%20not%20use%20page%20layout%20view%20nor%20do%20I%20have%20any%20cells%20protected.%26nbsp%3B%3C%2FSTRONG%3E%3C%2FU%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EToday%2C%20I%20am%20working%20on%20a%20very%20small%2C%20one%20worksheet%20workbook%20and%20I%20just%20cleared%20what%20I%20had%20frozen.%20Then%20after%20a%20bit%2C%20I%20decided%20to%20go%20ahead%20and%20freeze%20at%20row%205%20(before%20I%20had%20frozen%20at%20a%20column%20and%20a%20row).%20Well%2C%20freeze%20panes%20is%20grayed%20out!%20I%20saved%20my%20file%20and%20reopened%20it%20and%20it%20is%20still%20grayed%20out.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESee%20screen%20shot%20below%20(I%20created%20a%20custom%20ribbon).%20I%20am%20so%20tired%20of%20dealing%20with%20this%20issue%20-%20it's%20ridiculous.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22kkb_IHC_0-1581445782149.png%22%20style%3D%22width%3A%20158px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F170492i6BAD3A87D0F9DF2D%2Fimage-dimensions%2F158x105%3Fv%3D1.0%22%20width%3D%22158%22%20height%3D%22105%22%20title%3D%22kkb_IHC_0-1581445782149.png%22%20alt%3D%22kkb_IHC_0-1581445782149.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1167388%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFreeze%20Panes%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1204794%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1204794%22%20slang%3D%22en-US%22%3E%3CP%3ENobody%20has%20this%20issue%3F%20It%20happens%20to%20me%20all%20the%20time%20in%20different%20workbooks.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

I'm using Office 365, have my spreadsheets on OneDrive. I keep hitting on this issue where all of a sudden, when working on a spreadsheet, freeze panes will be grayed out. Usually, I can save my file, reopen it, and freeze panes is available again.

 

I do not use page layout view nor do I have any cells protected. 

 

Today, I am working on a very small, one worksheet workbook and I just cleared what I had frozen. Then after a bit, I decided to go ahead and freeze at row 5 (before I had frozen at a column and a row). Well, freeze panes is grayed out! I saved my file and reopened it and it is still grayed out.

 

See screen shot below (I created a custom ribbon). I am so tired of dealing with this issue - it's ridiculous.

 

kkb_IHC_0-1581445782149.png

 

2 Replies

Nobody has this issue? It happens to me all the time in different workbooks.

@kkb_IHC 

Bump - I continue to have this issue. Someone please weigh in.