How to Backup Excel Files to a Flash Drive – 4 Methods

This is the sample dataset.

Method 1. Manually Backup Excel Files to a Flash Drive

Steps:

• Click File.

• Select Save As.

• Click Browse.

• Select a folder in the flash drive and click Save.

A backup copy is created.

Read More: How to Find Backup Files in Excel

Method 2 – Automatically Backup Excel Files to a Flash Drive

Steps:

• Click File.

• Click Options.

The Excel Options dialog box will open.

• Click Save.
• Check Save AutoRecover information every and set the time. Here, 10 minutes.
• Enter the folder location in AutoRecover file location box.
• Click OK.

Excel will automatically Save the file after every 10 minutes.

Excel created a backup automatically.

Read More: How to Auto Backup Excel File

Method 3 – Applying the Always Create Backup Option to Backup Excel Files

Steps:

• Follow the first three steps in the first method to open the Save As dialog box.
• Select General Options in Tools.

• Check Always create backup.

• Click Save.

A backup is created. The backup file name will be the same, including – ‘Backup’ in front of the original name.

Method 4 – Embed Excel VBA to Backup Files to a Flash Drive

Steps:

• Press Alt + F11 to open the VBA window.
• Click: Insert >> Module to create a new module.

• Enter the following code in the module.

Sub Backup_Files()
ActiveWorkbook.SaveCopyAs "D:\ExcelDemy\" + ActiveWorkbook.Name
ActiveWorkbook.Save
End Sub

• Click Run.

• Select the Macro Name.
• Click Run.

A backup copy is saved in the flash drive.

Download Practice Workbook

Download the free Excel template here and practice.

Related Articles

• How to Recover Excel File after Crash
• How to Recover Previous Version of Excel File
• How to Recover Overwritten Excel File with No Previous Version
• How to Recover Permanently Deleted Excel Files Online
• How to Undo Changes in Excel after Save and Close
• [Fixed:] Unsaved Excel File Not in Recovery
• How to Recover Corrupted Excel File
• How to Recover Corrupted Excel Files from USB

<< Go Back to Recover Excel File | Excel Files | Learn Excel