Methods to Robotically Backup Recordsdata in Excel

Darrera actualització: 04/10/2024

Microsoft Excel can routinely save earlier variations of your workbook. Heu de beneitar les steps per a routinely backup information in Excel.

Automatically Backup Files in Excel

Robotically Backup Recordsdata in Excel

Aix you could have skilled, unintentional deletions or modifications in a sophisticated Excel worksheet could be tough to right. Els seus errors de part són trepitjats i wireds, particularment sense engageu-los en good deadline.

Heu de fer ready for such a risk per a fer servir l'AutoBackup característica d'Excel, que routinely creats a backup copy of your authentic Excel File.

Auto Backup classic makes a rèplica de la seva Excel File whenever vostè pot ser considerat per primera vegada. Les lletres return a la còpia de seguretat, en cas d'unintentionally delete 1 thing or make undesirable modificacions within working File.

Each time you save the unique file, the backup file can be up to date. Aquest virtualment implica que el copyright es tot el temps per a un model mitjançant aquest standing de l'Excel file que es engage on.

Word : Heu de trobar la Backup Copy a la mateixa localització/folder com a unique file.

Methods to Setup Auto Backup in Excel

Observeu the steps beneath to Robotically Backup Recordsdata in Excel.

1. Click on on File tab situat within the high menu bar.

File Tab in Excel

2. Within the menu that seems, click on on Save As with the aspect menu after which click on on Extra choices…

Save As More Options in Excel

Word: Within the earlier variations of Excel (previous to 2016) t'has de poder capable a skip this step.

3. On subsequent display, click on the Instruments button after which click on on Basic Choices… within the instruments drop-down menu.

Save As Tools General Options in Excel

4. On el Basic choices pop-up, examine la llitera field subsequent to All times create backup and click on on OK.

  Com solucionar la pantalla borrosa a Windows 10

Always Create Backup Option in Excel

5. Subsequent, click on Save with the Save As window.

After this setting, Microsoft Excel ha creat backup copy of your present working Excel File and routinely replace the backup file, in order that it at all times stays un model behind your present working File.

  • Methods to Repair Microsoft Excel No respondre Error in Home finestres 10
  • Methods to Lock Cells In Excel to Defend Them