Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

[Fixed!] Move or Copy Sheet Not Working in Excel

Move or Copy sheet is a very useful feature in Excel. You can move or copy worksheets by using this feature. But, sometimes you may face a situation when the Move or Copy sheet is not working. The objective of this article is to explain the reasons why the Move or Copy sheet is not working in Excel with solutions.


Download Practice Workbook

You can download the practice workbook from here.


2 Reasons with Solutions When Move or Copy Sheet Operation Is Not Working in Excel

To explain this article, I have taken the following dataset. This dataset contains Employee Information. I named this Excel sheet Dataset. I have a few more sheets in this workbook.

Dataset for Move or Copy Sheet Not Working in Excel

Here, I have another Excel sheet named Contact Information. I will use these sheets to explain this article.

Sheet Named Contact Information for Move or Copy Sheet in Excel not Working


Reason-01: Having Excel Table in Grouped Worksheets

If you have one or more tables in the grouped worksheet you will not be able to Move or Copy the grouped worksheet. Let me show you the problem in detail.

Steps:

  • Firstly, press and hold the Ctrl key and select the Excel sheets you want to move.

Having Excel Table in Grouped Worksheets

  • Secondly, Right-click on the selected worksheets.
  • Thirdly, select Move or Copy.

  • Then, the Move or Copy dialog box will appear.
  • Select where you want to move the worksheets. Here, I selected (move to end).
  • After that, check the Create a copy option.
  • Next, select OK.

Move or Copy Dialog box in Excel While not Working

  • Here, you will see a Warning will appear. The reason behind this is I have a table in the selected worksheets.
  • Select OK to remove the Warning.

Warning Message for Move or Copy Sheet Not Working in Excel


Solution: Copy Single Worksheet at a Time

To solve this problem you can copy a single worksheet at a time. You will have to handle the worksheet that contains the table singly. Then, you can move the other sheets group-wise. Let’s see the steps.

Steps:

  • In the beginning, Right-click on the sheet name tab where the table is.
  • Then, select Move or Copy.

Copy Single Worksheet at a Time

  • Next, the Move or Copy dialog box will appear.
  • Then, select where you want to copy or move the worksheet. Here, I selected (move to end).
  • Afterward, check the Create a copy option if you want to copy the worksheet.
  • Further, select OK.

  • Now, you will see that you have copied the Excel sheet and moved it to your desired location.

  • After that, copy the other worksheets in the same way.

Read More: How to Copy Sheet to End in Excel Using VBA (6 Methods)


Reason-02: Moving or Copying Worksheets in Protected Workbook

Another reason for Move or Copy sheet not working in Excel is moving or copying worksheets in a protected workbook. In this case, when you try to move a sheet in Excel, you will see that the Move or Copy option is blurred out.

Moving or Copying Worksheets in Protected Workbook

To check this, go to the Review tab from the Ribbon, and then you will see that the Protect Workbook command is selected.

Move or Copy Sheet in Excel not Working Because of Protected Workbook


Solution: Unprotect Workbook

You can solve this problem easily by unprotecting the workbook. Let’s see how you can do it.

Steps:

  • Firstly, go to the Review tab.
  • Secondly, click on Protect Workbook.

Unprotect Workbook when Move or Copy Sheet Not Working in Excel

  • After that, you will see that the Protect Workbook is not selected anymore.

Goinh to Review tab When Move or Copy Sheet not working in Excel

  • Then, Right-click on the sheet name tab where the table is.
  • Next, select Move or Copy.

Selectiong Move or Copy Sheet Feature when it is not Working in Excel

  • Afterward, the Move or Copy dialog box will appear.
  • Next, select where you want to copy or move the worksheet. Here, I selected (move to end).
  • Then, check the Create a copy option if you want to copy the worksheet.
  • Lastly, select OK.

  • Finally, you will see that you have copied the worksheet and moved it to your desired location.

Read More: VBA Copy Sheet in Excel (13 Quick Ways)


Similar Readings


How to Move or Copy Sheet to Another Workbook Without Reference in Excel

In this section, I will show you how you can Move or Copya sheet to another workbook without reference in Excel. For this example, I have taken another Excel workbook named Salary_Information. Here, I have created a sheet named Salary Information.

How to Move or Copy Sheet to Another Workbook Without Reference in Excel

I will copy and move the Contact Information sheet to this workbook. This sheet contains references from another sheet of that workbook. I will show you how you can Move or Copy a sheet to another workbook without reference in Excel.

Let’s see the steps.

Steps:

  • To begin with, Right-click on the sheet name of the sheet you want to move or copy.
  • Then, select Move or Copy.

  • After that, click on the drop-down option for To book.
  • Then, select the workbook where you want to copy or move the Excel sheet.

  • Afterward, select where you want to copy or move the worksheet. Here, I selected (move to end).
  • Next, check the Create a copy option if you want to copy the worksheet.
  • Then, select OK.

  • Finally, you will see that you have copied the worksheet and moved it to your desired location in the selected workbook.

  • In the following image, you can see that the Excel sheet still contains the references.

  • To remove the references, go to the Data tab.
  • Then, select Edit Links.

  • Here, the Edit Links dialog box will appear.
  • Select Break Link.

  • After that, a Warning Message will appear.
  • Select Break Links.

  • Then, select Close on the Edit Links dialog box.

  • In the end, you will see that the references are removed from the sheet.

Read More: Excel VBA: Copy Worksheet to Another Workbook Without Opening


Conclusion

To conclude, I tried to explain the reasons with solutions why the Move or Copy sheet is not working in Excel. Here, I also explained how to Move or Copy a sheet to another workbook without reference in Excel. I hope this article was helpful to you. For more articles, visit ExcelDemy. If you have any questions, feel free to comment.


Related Articles

Mashhura

Mashhura

Hey! Welcome to my profile. Right now, I am doing research on Microsoft Excel. I will be posting articles related to this here. My last educational degree was B.Sc in Industrial and Production Engineering from Bangladesh University of Engineering and Technology. I like to explore new things and find the best and most innovative solutions in every situation.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo