Monday, September 27, 2021

Save a copy before editing to prevent changing the original file

Tip: Did you make unwanted changes before saving a copy? No worries! You can go back to the original file, select the document title above the ribbon and Restore a previous version of a file with Version History.

< More collaboration scenarios

Before Microsoft 365, you would edit a file and then use Save As to save your changes as a new document. These days with AutoSave, your changes are always being saved so you won't lose your work. To make sure you don't accidentally save changes in the original file, use Save a Copy BEFORE you start making your edits to ensure you're working on the new copy and not overwriting the original.

Use an existing file in the cloud as a template for a new file using Save a Copy.

Todd's story about AutoSave and Save a Copy

Open the file you want to copy

Inga uses a monthly Excel budget report that she created to keep track of her team's expenses for reimbursement.

Todd has recently become manager of his own team and wants to keep track of his own monthly expenses. Instead of doing the work from scratch, he decides it would be more efficient to use Inga's budget report as a template.

Todd wants to use an existing report as a template for his own report.

Save a Copy to use as a starting point

Todd goes into Inga's team SharePoint site and opens the Excel budget report for the latest month. Since the spreadsheet is in the cloud, Todd knows that AutoSave will automatically save his changes to the file if he makes them.

Because he doesn't want to overwrite Inga's data, before he makes any changes, he goes to File and clicks Save a Copy to download a copy of the report into his OneDrive.

Todd uses Save a Copy to save his own version of the report in his OneDrive.

Make changes to your copied file

After saving to his OneDrive, Office automatically opens the file in Excel. Now Todd is working in his version of Inga's report and is safe to make changes without worrying about changing her data.

He changes the title and cost center number of the report and clears the fields he needs to make it ready for him to fill out. Todd knows that with AutoSave, his report will always save the latest changes.

With AutoSave, Todd knows the changes he makes in his report are safe.

Discard unwanted edits with Version History

Todd has made several copies of his budget report in preparation for the months ahead. However, he just realized that the report he's been updating with numbers for the next month, is actually the report for last month. Though his changes have been saving automatically over his data, Todd isn't worried because he can Restore a previous version of a file with Version History.

He selects the title of his budget report and selects Version History. He can see the different points in time where Excel has created a version of his file and he opens the one without his accidental changes in a new window. Now, he can easily restore his file with no damage done!

Where is Save As?

Use Version History to go back to a previous version of a file.

1 comment:

  1. Hello Everyone,

    Welcome to the future! Financing made easy with Prof. Mrs. DOROTHY LOAN INVESTMENTS

    Have you been looking for financing options for your new business plans, Are you seeking for a loan to expand your existing business, Do you find yourself in a bit of trouble with unpaid bills and you don’t know which way to go or where to turn to? Have you been turned down by your banks? MRS. DOROTHY LOAN INVESTMENTS says YES when your banks say NO. Contact us as we offer financial services at a low and affordable interest rate of 2% for long and short term loans. Interested applicants should contact us for further loan acquisition procedures via profdorothyinvestments@gmail.com

    Services rendered include:

    *Refinancing Loans
    * Car Loan
    *Truck Loans
    * Home Loan
    * Mortgage Loan
    * Debt Consolidation Loan
    * Business Loan [secure and unsecured]
    * Personal Loan [secure and unsecured]
    * Students Loan and so many others.

    For more info; Contact us via Email: profdorothyinvestments@gmail.com

    With Prof. Mrs. DOROTHY LOAN INVESTMENTS. you can say goodbye to all your financial crisis and difficulties as we are certified, trustworthy, reliable, efficient, fast and dynamic

    ReplyDelete