Office Settings & Configuration

How to Fix Excel Insert Options Disabled and Formulas Copying as Values

Rana GarciaRana Garcia Oct 29, 2026 870 views

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.

How to Fix Excel Insert Options Disabled and Formulas Copying as 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.
Before you start

Ensure that all active Excel workbooks are completely closed and your work is saved before modifying hidden system configuration files.

Solution 1Recommended

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.

1
Open File Explorer

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.

2
Enable Hidden Items

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'.

3
Rename the Configuration File

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.

4
Restart Excel

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.

Reset the Excel User Settings (.xlb) File
Safe Settings Reset: Renaming this file will not delete your spreadsheets or macros. It only resets custom toolbar and ribbon interface preferences back to their factory defaults.
Free Microsoft Office alternative

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. 1. Download and Install: Visit the official WPS website to download the free WPS Office suite and install it on your computer.
  2. 2. Open Your Existing Files: Launch WPS Spreadsheet and open your existing Excel workbooks directly without any format conversion.
  3. 3. Edit Without Restrictions: Enjoy immediate access to all Insert functions and seamless formula copying across your worksheets.
Fully compatible with Microsoft Excel formats including .xlsx, .xls, and .csv.Lightweight architecture minimizes the risk of configuration and profile corruption.Familiar tabbed interface ensures a seamless transition with zero learning curve.Reliable advanced formula calculations without frustrating clipboard pasting issues.
microsoft office alternative - wps office

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.