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:
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.
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.
Ask the experts
Connect with experts, discuss the latest Excel news, updates, and best practices, and read our blog.
Get help in the community
Ask a question and find solutions from Support Agents, MVPs, Engineers, and other Excel users.
Suggest a new feature
We love reading your suggestions and feedback! Share your thoughts. We're listening.