Mark the reply as an answer if you find it is helpful. Please provide more information about your problem and I'm glad to help you. I suggest you refer to this support article and try methods it provides: What comes up is a list of COM-Add Ins that Then click the drop-down arrow at the bottom of the dialog box and select 'COM Add-Ins' from the list, then click the GO button. In this example, we want to freeze rows 1 to 6, so weve selected row 7. If you want to freeze columns, select the cell immediately to the right of the column you want to freeze. This issue might be caused by several reasons, first I suggest you try to open file in safe mode, if it works in safe mode please try to disable add-ins:Ĭlick File > Excel Options > Add-Ins on the left side of the dialog. Select the row right below the row or rows you want to freeze.
What comes up is a list of COM-Add Ins that are loaded and running. Then click the drop-down arrow at the bottom of the dialog box and select 'COM Add-Ins' from the list, then click the GO button. Where did you open files? From local computer or network? Click File > Excel Options > Add-Ins on the left side of the dialog. Proceed with step 4 to try to fix the issue. If Excel opens with the above steps, it is likely that a plugin or other software is installed that is interfering with the software. Did this issue appear in all Excel files? Hold the Windows Key and press R to bring up the Run dialog box.
