'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix Excel for the Web Missing 'Create a Copy Online' Option
Question details
Users are unable to locate the 'Create a copy online' option in Excel for the web, while others on the same computer can see it. Only 'Download a copy' is visible to affected users.
- Product
- Microsoft Excel for the Web
- Device & OS
- not provided
- Scenario
- Attempting to duplicate an online workbook within the Microsoft 365 web interface.
- Observed behavior
- The 'Create a copy online' option is missing from the File menu, and only 'Download a copy' is available. This discrepancy follows the user's online profile rather than the device.
Ensure you are actively logged into your Microsoft 365 account on the web and verify that your internet connection is stable before troubleshooting.
Check Alternative Menu Locations
Microsoft sometimes shifts menu items depending on the interface version; check if the option is located under the Save As menu.
Click on 'File' in the top-left corner of the Excel for the web interface.
Select the 'Save as' tab instead of 'Create a copy' to see if the 'Save a copy online' option is available there.
Verify File Sharing and Ownership Permissions
Files shared by other users may restrict your ability to create an online copy depending on their custom permission settings.
Compare Microsoft 365 Account Profiles
Because the issue follows the user profile rather than the device, verify that the affected account has the correct Microsoft 365 license and access rights.
Avoid Cloud Permission Issues with WPS Office
Struggling with confusing online permissions and missing web features? Switch to WPS Office for a robust, free, and fully-featured desktop suite that gives you complete control over saving, copying, and managing your files locally and in the cloud.
Frequently Asked Questions
Why does the 'Create a copy online' option disappear for certain users?
This feature is tied to your Microsoft 365 profile permissions and subscription level. It can also be restricted if you are working on a file shared by someone else who has limited your duplication rights.
Can I still copy the file if the online option is missing?
Yes, you can select 'Download a copy' from the File menu to save the file locally to your computer, and then upload it back to your cloud storage manually if needed.
Does clearing my browser cache fix missing Excel web options?
If the issue is caused by a glitch or an outdated session token, clearing your browser cache and cookies can force Excel for the web to reload your profile's correct permissions and interface options.
