Excel 2016 - Automatic Backup

Question

Below are steps I've taken to enable automatic backup of an Excel workbook. However, current version is visible when I try to open the workbook. Is there an issue with automatic backup setting in Excel 2016?

---

STEPS FOR ENABLING AUTOMATIC BACKUP

1. Go to File > Save As.
2. Click "More options…" under the save location.
3. Click the Tools button then General Options in the Save As dialog window.
4. Check the box next to "Always create backup"
5. Click OK.
6. Click Save in the Save dialog window.

Answer 1

Hi,

You can follow the steps given below to and check if it helps.

a) Sign in to your OneDrive account.

b) Click on the nine square block present on the top left corner and then click on the type of file with which you face the issue.

c) Click on the three dots present on the top right corner then click on previous version option.

d) It will show you other version with dates on the left pane of the screen. Click on the date and click on Restore.

Hope this information helps you. Please let us know if you need additional information.

Thank you.

Answer 2

I meant to say that current version of workbooks are visible in OneDrive, but not backup versions (both are visible when workbooks are saved to hard drive of PC. File name extensions are enabled. I am a using Office 2016 (not Office 365) and Windows 10.

Answer 3

Hi.  It saved ok to OneDrive for me.

I'm not sure what the question is:  "...However, current version is visible "

I would think that one "Would" want the current version visible.

Seems like the backup  worked fine.  You have your "Test" file, and "Backup of Test" file.

In File Explorer, go to the view tab, and enable "File Name Extensions"

You should see that the "Backup of Test" has an ".xlk" file extension.  This is Excel's Backup file extension name.

You should also see it in the "Type" column.

Answer 4

Below is screen capture showing Backup file created by Excel when saving workbook to PC.

Backup file is not created by Excel when saving workbook to OneDrive.  However,

Does OneDrive Support Backup? Is there a setting that I need to change in OneDrive?

Answer 5

Hi,

Welcome to Microsoft Community.

I would like to know if you get any error messages.

Could you kindly mention the Office build you have on the computer?

Let us try to repair Office from the control panel and check.

https://support.office.com/en-US/Article/Repair-an-Office-application-7821d4b6-7c1d-4205-aa0e-a6b40c5bb88b

If you are still having issues , Kindly upload a screen shot of the same, it would be helpful to understand the issue better.

http://answers.microsoft.com/en-us/windows/wiki/windows\_other-windows\_programs/how-to-include-a-screenshot-in-your-post/2594b08e-32a3-476a-85a6-b021181be7e4

Do come back with the required information and we would be glad to assist you.

Thank you.