Help with Freeze Pane in Office Professional Plus 2019

%3CLINGO-SUB%20id%3D%22lingo-sub-2013717%22%20slang%3D%22en-US%22%3EHelp%20with%20Freeze%20Pane%20in%20Office%20Professional%20Plus%202019%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2013717%22%20slang%3D%22en-US%22%3E%3CP%3EWhile%20you%20are%20in%20normal%20view%20and%20the%20protect%20worksheet%2Fworkbook%20is%20unlocked%20and%20still%20the%20Freeze%20Pane%20Icon%20is%20grayed%20out%3F%26nbsp%3B%20Office%20Professional%20Plus%202019%20version.%3C%2FP%3E%3CP%3EThanks%20for%20any%20help%2C%3C%2FP%3E%3CP%3EFred%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2013717%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2013861%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20Freeze%20Pane%20in%20Office%20Professional%20Plus%202019%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2013861%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F909888%22%20target%3D%22_blank%22%3E%40namzaps%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20this%20behavior%20for%20all%20the%20work%20or%20only%20for%20a%20specific%20work%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%2C%20Faraz%20Shaikh%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2014485%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20Freeze%20Pane%20in%20Office%20Professional%20Plus%202019%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2014485%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F156456%22%20target%3D%22_blank%22%3E%40Faraz%20Shaikh%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHmm.%26nbsp%3B%20That%20is%20strange%20Faraz.%26nbsp%3B%20It%20does%20appear%20to%20be%20just%20this%20one%20XLSX%20file.%26nbsp%3B%20I%20tried%20several%20newer%20files%20and%20older%20files%20and%20the%20freeze%20pane%20is%20not%20grayed%20out%20on%20those.%3C%2FP%3E%3CP%3EI%20also%20noticed%20on%20the%20one%20file%20my%20New%20Window%20and%20Split%20icons%20are%20grayed%20out%20as%20well.%3C%2FP%3E%3CP%3EI%20tried%20doing%20a%20side%20by%20side%20comparison%20on%20this%20file%20and%20another.%26nbsp%3B%20Each%20tab%20was%20the%20same%20except%20for%20the%20view%20tab%20which%20has%20those%20grayed%20out%20icons.%3C%2FP%3E%3CP%3EVery%20Strange.%3C%2FP%3E%3CP%3EThank%20you%20for%20any%20help%20that%20may%20be%20provided.%3C%2FP%3E%3CP%3EFred%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

While you are in normal view and the protect worksheet/workbook is unlocked and still the Freeze Pane Icon is grayed out?  Office Professional Plus 2019 version.

Thanks for any help,

Fred

5 Replies

Hi @namzaps 

 

Is this behavior for all the work or only for a specific work?

 

Regards, Faraz Shaikh

@Faraz Shaikh 

Hmm.  That is strange Faraz.  It does appear to be just this one XLSX file.  I tried several newer files and older files and the freeze pane is not grayed out on those.

I also noticed on the one file my New Window and Split icons are grayed out as well.

I tried doing a side by side comparison on this file and another.  Each tab was the same except for the view tab which has those grayed out icons.

Very Strange.

Thank you for any help that may be provided.

Fred

Hi @namzaps ;

 

Can you please attached that excel file removing your sensitive information. This will help to debug the issue 

 

Regards, Faraz Shaikh

@Faraz Shaikh Sure Faraz.

One thing I did notice which is weird.  Goto File and then to Info.  It looks as thou this is a protected workbook.  I don't have any of the protections on.