Office Settings & Configuration

How to Fix Excel Cannot Rename Worksheets or Copy Data Between Workbooks

Kushani Nimanthika Oct 9, 2026 868 views

Question details

The user is unable to rename worksheets or copy data between workbooks in Excel, which is frequently caused by add-in conflicts or corrupted startup files.

How to Fix Excel Cannot Rename Worksheets or Copy Data Between Workbooks

Product: Microsoft Excel 365
Device & OS: not provided
Scenario: Attempting to rename worksheet tabs or transfer data across different Excel files.
Observed behavior: Excel fails to execute the renaming of worksheets or copying of data, and a standard software reinstallation does not resolve the conflicts.

Before you start

Ensure you have saved all your open workbooks and closed out of any active Excel instances. You will need to restart the application multiple times during this troubleshooting process.

Solution 1Recommended

Start Excel in Safe Mode and Isolate Add-ins

Use Safe Mode to determine if an add-in or startup file is blocking Excel functions, then systematically disable add-ins to identify the culprit.

Safe Mode starts Excel with minimal features and without third-party add-ins. This is the most effective way to pinpoint whether an extension is causing your worksheet and clipboard errors.

Launch Safe Mode

Press the Windows key + R to open the Run dialog box. Type 'excel /safe' and press Enter to launch Excel in Safe Mode.

Test Functionality

Open your workbooks and test if you can rename worksheets or copy data. If the actions work normally, the issue is likely caused by an active add-in.

Access Add-ins Menu

Close Excel and open it normally. Click on 'File' in the top-left corner, select 'Options', and then click 'Add-ins' on the left pane.

Disable COM Add-ins

At the bottom of the window, select 'COM Add-ins' from the Manage drop-down list and click 'Go'. Uncheck all add-ins in the list to disable them, then click 'OK'.

Identify the Problematic Add-in

Restart Excel and try renaming a worksheet. If it works, return to the COM Add-ins menu and enable them one at a time, restarting Excel after each, until the problem returns. Uninstall or permanently disable the add-in that causes the issue.

Add-in Isolation: If you do not have any COM Add-ins installed, repeat the isolation process for 'Excel Add-ins' from the Manage drop-down list.

Solution 2

Clear Excel Startup Folders and Update Office

Corrupted files in Excel's startup folders or outdated software versions can cause erratic behavior and prevent basic worksheet operations.

Free Microsoft Office alternative

Use WPS Office to Seamlessly Manage and Edit Spreadsheets

If Excel continues to freeze or block standard operations like renaming worksheets and copying data, consider switching to WPS Office. It provides a lightweight, highly compatible spreadsheet editor without the hassle of complex add-in conflicts.

1. Download and Install: Download WPS Office from the official website and run the quick installer.
2. Open Your Spreadsheets: Launch WPS Spreadsheets and open your existing .xlsx files. Your data and formatting will remain perfectly intact.
3. Manage Worksheets with Ease: Right-click any worksheet tab to instantly rename it, or safely copy and paste data between different open workbooks.

Fully compatible with Microsoft Excel formats including .xlsx, .xls, and .csv.Lightweight architecture ensures fast launching and smooth copying across multiple files.Free to use with a familiar, easy-to-navigate tabbed interface.Built-in advanced tools without relying on unstable third-party COM add-ins.

microsoft office alternative - wps office

Frequently Asked Questions

Why is the rename option grayed out when I right-click a worksheet tab?

The rename option can be disabled if the workbook structure is protected. To fix this, go to the Review tab on the ribbon, click 'Protect Workbook', and enter the password if prompted to unprotect the file structure.

Can a macro prevent me from copying data between workbooks?

Yes, certain VBA macros or event handlers (such as Worksheet_SelectionChange) might automatically clear the clipboard or restrict cell selection. Disabling macros temporarily via the Developer tab can help you identify if a script is the root cause.

What should I do if Excel Safe Mode doesn't fix the renaming issue?

If the issue persists in Safe Mode and clearing the XLSTART folders doesn't help, the problem might be related to a corrupted Office installation. Try running the Office Online Repair tool from the 'Apps & features' menu in your Windows Settings.

Office App Problems