Automatically Save a Backup Copy of a Workbook

我希望能將使用VBA或Power Automate將SharePoints上的Excel檔案設定每周可以自動備份檔案(另存新檔)。 我已嘗試了Excel自動存檔設定，再加上VBA程式定期 ...

Backup files in Excel usually located in Documents folder. However, it still depends on the folder you choose when saving the backup file.

在Microsoft Office 中儲存、備份及復原檔案 請按CTRL+S 或選取[檔案> 儲存]。 提示: 您也可以選取[快速存取工具列] 上的[儲存 ]。 如果您是第一次儲存，您必須輸入檔案的名稱。

Choose the Tools button, then General Options in the Save As dialog window. Check the box next to “Always create backup“; Click OK.

Learn how to use Excel backup features to retrieve an unsaved workbook or restore the previous version of an overwritten file.

This automatic backup feature gives you the option to restore the Excel file when you restart the program if it was not closed properly the last time.

Excel backup files are typically located in the same folder as the original Excel file, with the file extension .xlsx replaced by .xlsx.

If you really need a backup you can use a 3rd party tool. Does that help?

How To Automatically Backup A Workbook With Microsoft Excel Have questions about Microsoft Office 365 and any of the products in Microsoft ...