Forum Discussion
Excel 2019 Save As - More Options
Windows 10 Enterprise 21H1 Microsoft Excel 2019 I want to save an excel file to My Google Drive and automatically backup that same file to an external hard drive on my PC. Here is what I found....
In Excel for Windows, there is a Tools dropdown to the left of the Save button in the Save As dialog.
The third option in the dropdown menu is General Options...
The dialog contains a check box 'Always create backup'.
It won't do what you want, however. Each time you save the workbook, it will save a backup copy in the same folder as the workbook itself. You cannot choose another target folder. You'd need to use VBA code for that.