How to Fix Excel Insert Options Disabled and Formulas Copying as Values
Question details
The user needs to restore normal functionality in Excel where Insert options are grayed out and copying formulas incorrectly pastes only static values.

- Product
- Microsoft Excel 2016
- Device & OS
- Windows
- Scenario
- Attempting to insert rows, columns, or objects from the ribbon, and trying to copy and paste formulas across different cells.
- Observed behavior
- The Insert commands in the ribbon are completely disabled (grayed out). Additionally, copying a formula and pasting it into another cell results in only the calculated value appearing, requiring the user to re-enter the formula manually. Standard repair and reinstallation of Office failed to resolve the problem.
Ensure that all active Excel workbooks are completely closed and your work is saved before modifying hidden system configuration files.
Reset the Excel User Settings (.xlb) File
Corrupted configuration files stored in the Windows user profile can cause persistent ribbon and clipboard glitches that survive an app reinstall. Renaming the configuration file forces Excel to build a fresh, error-free settings file.
Uninstalling or repairing Microsoft Office often leaves user-specific AppData folders intact, which is why a reinstall doesn't fix profile-level corruption. Resetting the .xlb file manually clears these persistent configuration bugs.
Press the Windows Key + E on your keyboard to open File Explorer. In the address bar, type or navigate to C:\Users\[Your User Name]\AppData\Roaming\Microsoft\Excel.
If you cannot see the AppData folder, click the 'View' tab at the top of the File Explorer window and check the box for 'Hidden items'.
Locate the file named Excel15.xlb (the number may vary based on your Office version, such as Excel16.xlb). Right-click the file and select 'Rename'. Change the name to Excel15.old.
Launch Microsoft Excel again. Test the ribbon to see if the Insert options are re-enabled, and try copying a formula to verify it pastes correctly.

Verify Worksheet Protection and Calculation Options
If resetting the configuration file does not work, the issue may be caused by document-level settings such as worksheet protection or manual calculation modes.
Switch to WPS Office for a Reliable Spreadsheet Experience
If Microsoft Excel continues to experience corrupted settings or persistent bugs even after a reinstall, consider switching to WPS Office. It provides a lightweight, highly compatible, and free alternative with robust formula handling and zero persistent configuration errors.
- 1. Download and Install: Visit the official WPS website to download the free WPS Office suite and install it on your computer.
- 2. Open Your Existing Files: Launch WPS Spreadsheet and open your existing Excel workbooks directly without any format conversion.
- 3. Edit Without Restrictions: Enjoy immediate access to all Insert functions and seamless formula copying across your worksheets.

Frequently Asked Questions
Why are the Insert options grayed out in Excel?
Insert options typically gray out if the worksheet or workbook is protected with a password, if multiple sheets are grouped together, or if the underlying Excel user configuration file (.xlb) has become corrupted.
Why do my Excel formulas copy as values instead of the actual formula?
This commonly happens if Excel's calculation option is set to Manual instead of Automatic, preventing the pasted formula from updating. It can also be caused by clipboard glitches linked to corrupted roaming profile settings.
Will reinstalling Office fix grayed-out menus?
Not always. Reinstalling or repairing Microsoft Office often leaves your local AppData user profile files intact. If the configuration file (like Excel15.xlb) is corrupted, you must manually rename or delete it to resolve the issue.
Is it safe to rename the .xlb file in AppData?
Yes, it is completely safe. The .xlb file only stores customizations you've made to the ribbon and toolbars. Renaming it forces Excel to generate a brand new, error-free default file the next time it opens, without affecting any of your actual spreadsheet data.




