SOLVED

Excel Freeze Panes error permanently freezes part of sheet even when unfrozen.

%3CLINGO-SUB%20id%3D%22lingo-sub-3066566%22%20slang%3D%22en-US%22%3EExcel%20Freeze%20Panes%20error%20permanently%20freezes%20part%20of%20sheet%20even%20when%20unfrozen.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3066566%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20seen%20this%20issue%20before%20and%20never%20knew%20how%20to%20fix%20it.%20Normally%20I%20would%20just%20copy%20whatever%20I%20need%20into%20a%20new%20sheet%20and%20scrap%20it%2C%20but%20this%20table%20is%20linked%20to%20a%20PowerApps%20form%20I'm%20working%20on%2C%20and%20I'm%20worried%20it'll%20screw%20everything%20up%20if%20I%20relocate%20the%20table.%20The%20duplicate%20row%201%20in%20the%20picture%20below%20is%20always%20there%20no%20matter%20where%20I%20am%20in%20the%20sheet%20even%20though%20there%20is%20no%20active%20freeze%20being%20applied%20to%20the%20sheet.%20This%20error%20has%20happened%20when%20changing%20the%20freeze%20settings%2C%20but%20I'm%20not%20sure%20what%20other%20factors%20cause%20it.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20anyone%20have%20a%20fix%20for%20this%3F%20I%20couldn't%20find%20any%20other%20posts%20about%20this%20issue.%20Thanks%20a%20lot!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22tablefreezeerror.PNG%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F340871i74A72BDB9F7689A6%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22tablefreezeerror.PNG%22%20alt%3D%22tablefreezeerror.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3066566%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

I've seen this issue before and never knew how to fix it. Normally I would just copy whatever I need into a new sheet and scrap it, but this table is linked to a PowerApps form I'm working on, and I'm worried it'll screw everything up if I relocate the table. The duplicate row 1 in the picture below is always there no matter where I am in the sheet even though there is no active freeze being applied to the sheet. This error has happened when changing the freeze settings, but I'm not sure what other factors cause it. 

 

Does anyone have a fix for this? I couldn't find any other posts about this issue. Thanks a lot!

 

tablefreezeerror.PNG

3 Replies
I actually figured out a solution. If you open a new window, then close the first one, the problem disappears. Still don't know what causes it, though...
best response confirmed by tjryan35 (Occasional Contributor)
Solution

@tjryan35 Looks like you accidentally activated "Split screen" in stead of "Freeze Panes". It just creates two or more viewing areas of the shame sheet. So you could create a view like this (just an example):

 

Screenshot 2022-01-20 at 06.38.57.png

 

Press "Split" again to switch it off.

 

@Riny_van_Eekelen 

 

Yep, you nailed it. I've done splits before, but I didn't recognize it on just the top row like that. That's happened to me inadvertently before when using freeze panes in a macro. Now I know how to easily fix it. Thank you!!