Share via

ORIGINAL EXCEL SHEET

Martha Lopez 0 Reputation points
2026-03-30T16:17:06.5233333+00:00

I MEANT TO CREATE A SECOND EXCEL SHEET BUT STILL KEEP ORIGINAL

I DID CLICK ON THE VERSION HISTORY BUT IT'S NOT WORKING

IS THERE ANOTHER WAY

Microsoft 365 and Office | Excel | Other | Other
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Q&A Assist
    2026-03-30T16:17:16.6066667+00:00
    AI generated content. This question contains an answer created with AI from Q&A Assist. Learn more

    To keep the original Excel file and work on a second copy, use one of these methods.

    If the file is stored in OneDrive or SharePoint (recommended so Version History works):

    1. Open the original file.
    2. Immediately create a separate copy:
      • Go to File > Save a Copy (instead of Save As when using OneDrive/SharePoint).
      • Give the copy a new name (for example, "MySheet_Copy") and save.
    3. Work only in the new copy so the original stays unchanged.

    If unwanted changes were already saved to the original and Version History is available:

    1. Open the file.
    2. Use Version History from within the app:
      • Either click the file name at the top and choose Version history, or
      • Go to File > Info and select Version History.
    3. In the Version History pane, select an earlier version to open it in a separate window.
    4. Choose one of these options:
      • Click Restore to roll the file back to that version (replaces the current version), or
      • Use File > Save a Copy on that older version to keep both the restored version and the current one as separate files.

    If Version History from the app is not working but the file is in OneDrive/SharePoint:

    1. Go to the folder in OneDrive/SharePoint where the file is stored.
    2. Right‑click the file and select Version history.
    3. Pick an older version, select the three dots (…) next to it, and choose Restore (or open/download that version as a separate file if offered).

    Going forward, whenever a new version is needed (for example, a new month), open last month’s file and immediately use File > Save a Copy to create the new file before making any edits.

    References:

    1 person found this answer helpful.
    0 comments
  2. Rodrigo Queiroz 77,145 Reputation points Independent Advisor
    2026-03-30T17:42:20.59+00:00

    Hi, I'm Rodrigo and I will help you.
    Do you want to create a new sheet in the same Excel file or duplicate the current Excel file to modify the copy?

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.