Freeze panes removed upon exiting workbook

[ShalDRH]

Hello! I have Excel for MS 365 and running into workbooks where the "freeze panes" seem to reset to nothing frozen upon opening each time.

They all have multiple tabs that have freeze panes enabled under the title bars for the data set, and the auto filter turned on. Pretty standard setup.

Everything works like normal except upon opening the workbook each time, nothing is frozen. I have to refreeze each time on each tab. Like it removes it automatically when I close the workbook. The autofilter stays intact but the freezing seems to reset to nothing.

This happens on a few files I have, but most files work as expected. I haven't been able to figure out anything that is different for these files other than they are "old" files originally created by a user long gone. They aren't something I started from scratch. They are all Macro_enabled .xlsm docs.

Is there some setting or checkbox somewhere that tells it not to save the frozen panes upon exit? I'm stumped.

Thanks-

 

[Alex Blakenburg]

No problem. Glad we could help and thanks for letting us know.
Happy Holidays to you too.

PS: If for interest you still wanted to track down the problem. The fact that saving it as .xlsx fixed indicates there is a macro running around in there somewhere.
In the original ".xlsm" file Try going to any code window (either module or sheet or ThisWorkbook), Ctrl+F, type in Freeze and Tick Current Project.
If and when it finds the word Freeze it should highlight where it finds it in the VBA Project window on the left in my test case it has highlighted ThisWorkbook. (The grey highlighting is a bit faint though)

 

[ShalDRH]

No problem. Glad we could help and thanks for letting us know.
Happy Holidays to you too.

PS: If for interest you still wanted to track down the problem. The fact that saving it as .xlsx fixed indicates there is a macro running around in there somewhere.
In the original ".xlsm" file Try going to any code window (either module or sheet or ThisWorkbook), Ctrl+F, type in Freeze and Tick Current Project.
If and when it finds the word Freeze it should highlight where it finds it in the VBA Project window on the left in my test case it has highlighted ThisWorkbook. (The grey highlighting is a bit faint though)

View attachment 54030

I'm totally still interested. Unresolved issues are what nightmares are made of. I'm going to have a nightmare of being cold and frozen while a weird little "macro monster" is lurking in the background...

I did Ctrl F to find it and still got nothing. (The crying face is a self-portrait of each time I open this workbook!) Thanks for your help. I must be missing something, or it for reals is a broken workbook.

 

[Alex Blakenburg]

If you want us to have a look and want to post a link to a public share of the workbook, happy to do so.
You can basically delete the content from the sheets and tell us which sheet and where you freeze the titles and we can have a play. (Don't delete anything structural eg whole sheets , user forms, modules or code)