If you are working on a large workbook with Excel and would like to automatically save it to a different partition every time you save it, you can do this with a small VBA script. To do this, the master file must then be saved as a workbook with a macro.