Copying Excel Files While Using OneDrive

J GALVAN PAULA 0 Reputation points
2026-11-17T21:04:15.97+00:00

When using OneDrive, there is no "Copy As" option in the drop down menu. How do I copy a file in Excel?

Microsoft 365 and Office | Excel | For home | Windows
0 comments No comments

2 answers

Sort by: Oldest
  1. AI answer

    2026-11-17T21:04:45.1733333+00:00

    Use File > Save a Copy in the Excel desktop app; OneDrive’s menu does not need a Copy As command to duplicate the workbook.

    Excel desktop app on Windows

    1. Open the workbook in Excel.
    2. Press F12, or select File > Save a Copy.
    3. Choose:
      • OneDrive – Personal to place the copy in your personal OneDrive.
      • This PC or Browse to save it locally.
    4. Enter a different file name.
    5. Select Save.

    The original workbook closes, and Excel switches to the newly created copy.^1^

    If your Excel version displays Save As instead, select File > Save As, choose OneDrive, enter a new name, and select Save. Save As creates a copy when you provide a different file name.^2^

    Excel in a web browser

    To download a separate copy:

    1. Open the workbook.
    2. Select File > Create a Copy > Download a Copy.
    3. When prompted, select Save.
    4. To put the copy back into OneDrive, open it in desktop Excel and use File > Save a Copy, selecting OneDrive as the destination.^3^

    If the workbook contains macros, retain the .xlsm format. Saving it as .xlsx removes the macros and may cause loss of functionality.^2^


    References

    1. [Microsoft 365](https://support.microsoft.com/office/collab-files/save-back-up-and-recover-a-file-in-microsoft-office#save-a-copy-as-a-new-file-save-as)
    2. Save your workbook
    3. Save a copy of a workbook to your computer | Microsoft Support
    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

  2. John Jefferson Doyon 91,205 Reputation points Independent Advisor
    2026-11-17T21:40:37.4666667+00:00

    Hi, @J GALVAN PAULA

    To help narrow this down:

    1. Are you opening the Excel file directly from the OneDrive folder in File Explorer or through OneDrive Web https://onedrive.live.com
    2. Are you trying to create a duplicate of the entire workbook or copy a worksheet within the same workbook?

    In the meantime, you can create a copy of the Excel workbook using these steps:

    • Open the workbook in Excel.
    • Select "File" > "Save a Copy" or "Save As".
    • Choose your OneDrive folder as the destination.
    • Enter a different file name and select "Save".

    This will create a separate copy while keeping the original file unchanged.


    Click "Add comment" to let me know.

    Thanks!

    Was this answer helpful?

    0 comments No comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.