Excel workbook cannot be moved or copied? Let's see if it's due to these two reasons

php editor Xinyi found that sometimes in Excel, you may encounter a situation where the workbook cannot be moved or copied. There are usually two main reasons for this problem. One is that the workbook may be protected, and the other is that the Excel application may be locked. Next, let us explore these two reasons together to solve the problem of Excel workbooks unable to be moved or copied.

Excel tables are divided into workbooks and worksheets. A workbook is the entire file, and a worksheet is a single table in the workbook.

Worksheets can be easily moved or copied, and the same operations can even be performed on worksheets between different workbooks. If you encounter an inoperable situation, it is usually due to two possible reasons. Check these two causes and you can find the solution to the problem.

Cause 1: The Excel workbook is not opened at the same time

If there are two Excel sheets, and you want to copy or move the worksheet of one of them to another workbook, you need to open both Excel sheets at the same time.

For example, if you want to move and copy the "SheetA" worksheet of Excel "Sheet 2" to "Sheet 1", you need to open both Excels at the same time.

Then right-click on "SheetA" of "Sheet 2" and select the [Move or Copy] option.

After the dialog box pops up, click the arrow drop-down list on the right side of the [Workbook] option, and select the workbook you want to move to. (Excel must be opened to be displayed here)

After selecting, you can also choose where to place the worksheet after moving to the new workbook in the [Before selected worksheet below] option.

If you need to copy and move the worksheet, please check [Create a copy]; if you only move it, there is no need to check it.

After completing the above operations, the worksheet will be moved to the specified location in the new workbook.

Cause 2: The workbook of the Excel spreadsheet is set to "restriction protection"

Excel tables can be set to "Protect Workbook". After setting, no matter whether it is a single Excel table or each worksheet between multiple Excels, it cannot be edited and changed at will.

As shown below, in a single Excel table, if you want to edit each worksheet, you will find that not only cannot "move or copy", but also a series of operations such as deleting, inserting new worksheets, renaming, etc. cannot be selected. The options are The gray state cannot be clicked.

Two Excel tables, as long as one table has "restriction protection" set, it cannot be "moved or copied". During the operation, a dialog box will pop up, prompting "The workbook is protected and cannot be changed".

So, if the above situation occurs, we need to lift the "restriction protection" of the Excel table so that the workbook can be "moved or copied" .

How to remove the restriction? Select [Protect Workbook] in the [Review] list in the menu directory of the Excel table. After the dialog box pops up, enter the originally set password in the password field. The protection of the Excel workbook will be lifted, and various edits can be performed.

How to remove the "restriction protection" of an Excel workbook if you forget your password? There is no "forgot password" option in the Excel table. If there is no password, we might as well use other tools, such as the Pepsi Niu Excel Password Recovery Tool, to directly remove the "restricted password" from the Excel workbook.

In the tool, select the [Unrestriction] module and import the Excel table.

Tool link: Pepsi Niu Excel Password Recovery Tool

The above is the detailed content of Excel workbook cannot be moved or copied? Let's see if it's due to these two reasons. For more information, please follow other related articles on the PHP Chinese website!