Applies ToExcel 2016

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

ISSUE

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.

STATUS: FIXED

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?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Find solutions to common problems or get help from a support agent.