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: Most helpful
  1. 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

  2. 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?

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.