Forum Discussion

namzaps's avatar
namzaps
Copper Contributor
Dec 23, 2020

Help with Freeze Pane in Office Professional Plus 2019

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

excel

5 Replies

    • namzaps's avatar
      namzaps
      Copper Contributor
      Dec 24, 2020

      ExcelExciting 

      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

      • ExcelExciting's avatar
        ExcelExciting
        MVP
        Dec 28, 2020

        Hi namzaps ;

         

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

         

        Regards, Faraz Shaikh