Then, try to install Office 2007 again and test the results.
How do I uninstall Office 2003, Office 2007 or Office 2010 suites if I cannot uninstall it from Control Panel? To completely uninstall the program, you can also follow the steps in this Microsoft Knowledge base article to remove the Office 2007 program first: If this still does not help, we can try to reinstall the Office program. Locate the Office program, right click it and choose Change. However, if the problem persists, please try to repair the Office programs from Add/Remove Programs (Windows XP) or Programs and Features (Windows Vista/Windows 7). This will see if Microsoft has released any special fixes for Office and Excel that are needed on your PC. To keep an area of a worksheet visible while you scroll to another area of the worksheet, go to the View tab, where you can Freeze Panes to lock specific row. Once the issue reappears again, we can determine which add-in causes this problem and then disable it. If the add-ins still do not work, reboot again and run the Temp File Deleter a third time. Add one check back each time to the list of Add-In, restart the Office program, and repeat the above procedure. Close the Office program and restart it.ĭ. I am running Office 2007.I am trying to freeze the top two rows in an Excel spreadsheet.I highlight the top two rows and use 'Freeze based on selection'. So, you need to unprotect Excel worksheet first. If it is protected then find and replace option won’t work. If your Excel find and replace not working then check whether your Excel sheet is password protected. Fix 5 Remove Password From Protected Excel Sheet. Check if there are any add-ins, clear the checkbox to disable them.Ĭ. Repeat step number 2 in each of our Excel worksheets. Click File menu, click Options > Add-in, click Go button in the Manage: Com-in Add.ī.
Normally, you could do the following to disable the conflict add-ins in your Excel program:Ī. If the problem does not occur in the safe mode, this issue might be related to some third-party add-ins in the Office program, we can try to disable them.
Press and hold the CTRL key, and then click Microsoft Excel. freeze pane greyed out, not accessible I'm running Excel for Mac 2008, and I continuously run into the problem that freeze pane simply isn't available. Click Start, point to All Programs, and then point to Microsoft Office.Ģ. I suggest trying to check this issue by starting Excel in safe mode first.ġ. This issue might be related to some third-party software conflicts or corrupted Excel components.