Backup excel file in different location with MacroĪn Excel macro is a set of programming instructions stored in what is known as VBA code. Next, I will introduce you two ways to backup Excel file in different location, one is using Macro, the other is using a third party tool – AOMEI Backupper. If one copy is lost, at least you have another one to recover it to the previous state. Therefore, it is better to backup Excel file in different location. Earlier versions of Excel: skip thisĬlick the Tools button then General Options in the Save As dialog window.Ĭheck the box next to "Always create backup"īe noticed that the backup copy saves in the same folder as the original one, if you meet hard disk failure or virus attack, you may lose the two filed simultaneously. How to create auto backup for excel fileįor Excel 2016, click "More options…" under the save location. If you do not create a backup of Excel files, accidental deletions or changes to a file can ruin your day. Excel is used to conduct calculation, research, data visualization in charts, data management, data analytics.
0 Comments
Leave a Reply. |