Freeze panes removed upon exiting workbook

ShalDRH

New Member
Joined
Jul 28, 2021
Messages
17
Office Version
  1. 365
Platform
  1. Windows
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-
 
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)

1640644159220.png
 
Last edited:
Upvote 0

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN
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.
Crying not frozen.png
 
Upvote 0
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)
 
Upvote 0

Forum statistics

Threads
1,223,099
Messages
6,170,107
Members
452,302
Latest member
TaMere

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top