Feb 11 2020
10:31 AM
- last edited on
Apr 01 2022
09:30 AM
by
TechCommunityAP
Feb 11 2020
10:31 AM
- last edited on
Apr 01 2022
09:30 AM
by
TechCommunityAP
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.
Mar 02 2020 08:54 AM
Nobody has this issue? It happens to me all the time in different workbooks.
Jul 07 2020 01:41 PM
Bump - I continue to have this issue. Someone please weigh in.