Dear @Susan Ferriola,
Good day! Welcome to Microsoft Q&A forum!
Based on your description, I understand that you and another user are unable to copy or duplicate worksheet tabs in the desktop version of Excel. While copying cells or ranges works normally, copying an entire worksheet results in a blank sheet. This issue started within the last week and is impacting your workflow. You have already verified that the workbook is not protected, no macros are running, sheets are not grouped, and both Move or Copy and Create a Copy options do not resolve the issue.
To help narrow down the cause, could you please confirm the following:
- What version and build of Excel are you currently using? (You could check at: File > Account > About Excel)
- Does this happen with all workbooks, or only specific files?
- If you create a brand-new workbook with a simple worksheet, can you successfully copy that sheet?
- Are both affected users running the same Excel version and build?
- Have there been any recent Office updates installed before the issue started?
Your confirmation would be very helpful in ensuring you receive the most suitable support!
In the meantime, kindly try the following suggestions to check what might have caused the issue:
- Start Excel in Safe Mode:
- Press Windows + R >Type excel /safe
- Open the workbook and test copying a worksheet
- Disable Excel add-ins:
- Go to File > Options > Add-ins > Manage COM Add-ins > Go
- Uncheck all add-ins and restart Excel
- Test in a new workbook: Kindly create a new workbook and attempt to duplicate a worksheet using Move or Copy > Create a Copy
- Run an Office repair following the step-by-step instructions from this article: Repair an Office application
I hope this information is helpful.
Kindly let me know when there are updates or if you need further assistance. Any updates you’re able to share would be really helpful. I appreciate your time and look forward to hearing how things are going!
Thank you for your time and patience.
If the answer is helpful, please click "Yes". If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in [forum documentation] to enable e-mail notifications if you want to receive the related email notification for this thread.