Important:  This issue is now closed with the fix indicated below. For more information on other recent issues for your application, see Fixes or workarounds for recent Office issues.

Last Updated: December 6, 2017


When you try to copy a sheet within the same workbook it moves the sheet instead of creating a duplicate sheet.

This is a bug that is in the Excel 2016 (16.0.4229.1002) preview version. This was fixed in the formally released (RTM) versions. There are no plans to fix this in the preview version.


To fix this issue, do the following:

  1. Uninstall the preview version of Office. Go to Control Panel and Program and Features, right-click your Office product, and choose Uninstall. For more information, go to Uninstall Office from a PC.

  2. Install a released version (RTM) of Office. Go to the Volume Licensing Service Center and install Office Professional Plus 2016, or your standalone Office applications.

  3. Turn on automatic updates. You can also check for the latest Public Update in Office Updates, to get additional information on other install methods.

More Resources

Icon Experts (brain, gears)

Ask the experts

Connect with experts, discuss the latest Excel news, updates, and best practices, and read our blog.

Excel Tech Community

Icon Community

Get help in the community

Ask a question and find solutions from Support Agents, MVPs, Engineers, and other Excel users.

Excel Forum on Answers

Icon feature request (light bulb, idea)

Suggest a new feature

We love reading your suggestions and feedback! Share your thoughts. We're listening.

Provide feedback

See Also

Fixes or workarounds for recent issues in Excel for Windows

Need more help?

Join the discussion
Ask the community
Get support
Contact Us

Was this information helpful?

What affected your experience?

Thank you for your feedback!