I am tempted to say it's a corrupted file but I can't prove it. Details: Freeze Panes in Excel is used to fix any frame or row or section of the table to access the data located so down. This works in a macro inside Excel Range('G2').Select ActiveWindow.FreezePanes True It does exactly what I'd expect. So there is something in there pretty deep. If you say yes, the panes remain frozen and you stay in Normal view. On the second sheet, if you go to Page Layout view, you get a warning that the panes are frozen, and will be unfrozen if you go to that view. I can just confirm that I am using the same OS/Office as you and see the same problem. Even stranger than the second sheet has Freeze Panes currently in effect but the button is grayed. This happens when you go to Page Layout View but you are in Normal View. I do not have answer yet but I have been unable to find the same situation anywhere. The second tab is an older tab that I was able to previously freeze the panes on. The first tab, which is a newer tab doesn't have frozen panes and I am unable to freeze them. Post the file but remove any sensitive data.Įnsure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them. Without seeing the file any of the solutions is possible. .chiave i have a dream speech animal pictures impossible eastside jurassic 5 activities kanya west apple cider vinegar sears portrait studio blindside.
#WHY DONT I HAVE FREEZE FRAME IN EXCEL WINDOWS#
I have Excel 2016 and am using Windows 10.
![why dont i have freeze frame in excel why dont i have freeze frame in excel](https://www.excelcampus.com/wp-content/uploads/2019/04/Gridlines-and-Freeze-Panes-Settings-Lost-in-New-Window.png)
It isn't all workbooks, so it is something specific to the workbook. Probably a stupid question, but I've searched all over and can't find out what I did to cause my freeze pane icon to become inactive in my workbook.
![why dont i have freeze frame in excel why dont i have freeze frame in excel](https://images.squarespace-cdn.com/content/v1/52b5f43ee4b02301e647b446/1391570050830-TB63N9RCBDG1K5NCABDP/Freeze+Pane+%26+Cell+Comments.jpg)
LinkBack Thread Tools Rate This Thread Display Freeze Panes greyed out