Why does an excel file appear a copy every time it is saved

Reason for a copy when saving: The Generate backup file option in the General Options dialog box was incorrectly checked during saving.

Uncheck the box to solve the problem that there will be a copy of the excel file every time it is saved, detailed steps:

1. When you want to save the document, click the [Save As] option in the Excel [File] menu.

2. Set the file name and save location on the [Save As] interface.

3. Click the [Tools] drop-down button shown in the [Save As] interface.

4. Click [General Options] in the drop-down menu.

5. Uncheck the [Generate Backup File] option shown in the general options dialog box.

6. Click the [OK] button.

7. Click the [Save] button again.

This copy is set to prevent Excel from being closed abnormally and the data cannot be recovered. Once Excel is closed abnormally, such as power failure, forced restart of the computer, end the task, etc., open Excel again, the system will prompt whether to restore the file, and this copy is used.

If you close excel normally, the file will disappear automatically. Leave it alone, it doesn't matter.

The same is true of Word.

When you close Excel, the file is gone.

Summary. Hello, glad to answer for you. About why does an excel document appear as a copy after opening?

During use, every action of the user may create a temporary file. However, most of the temporary files are automatically deleted after the task is completed, and some temporary files also disappear automatically after the system restarts.

In the case you mentioned, it is an automatically generated protection file, and the copy of the file you said will be automatically deleted after saving.

Why does an excel document appear as a copy after opening.

Hello, I am inquiring for you here, please wait a while, I will reply to you immediately

Hello, glad to answer for you. About why does an excel document appear as a copy after opening?

In the process of use, each action of the user may create a pre-burn file. However, most of the temporary files that have been carried early will be automatically deleted after the task is completed, and some temporary files will also disappear automatically after the system is restarted.

In the case you mentioned, it is an automatically generated protection file, and the copy of the file you said will be automatically deleted after saving.

I hope the above is helpful to you If you are satisfied with me, please give me a thumbs up

How to solve the problem of always saving a copy when saving a file in excel.

Hello dear! <>

When Excel saves a file, a copy is always saved, probably because the file's security settings are turned on<>

Here's how to fix it:1Open the Excel file, click the File tab, and select Options.

2.In the Excel Options dialog box, select the Sensitivity Settings option. 3.

In the "Sensitivity Settings" tab, find the "File Security Options" section and uncheck the "Always create backups" option. 4.Click the OK button to close the Excel Options dialog box.

5.Resave the excel file to see if a copy is still saved. Dear, you need to pay attention to the following <>

1.If the excel file is taken from another copy of the brain or on the network**, it may be affected by viruses or malware, resulting in always saving a copy. It is recommended to use antivirus software for scanning and cleaning.

2.If the Excel file is protected, you may need to enter a password to uncheck the "Always create backups" option. If you don't know the password, you can contact the creator or administrator of the file to unlock it.

3.If you always save a copy of an excel file when you save it, it may be because the folder where the file is located doesn't have write permissions. You can try copying the file to a different folder and then saving it again.

4.If you always save a copy of an excel file when you save it, it may be because the file name or path contains special characters, such as slashes, question marks, and so on. You can try modifying the file name or path and then re-save.

How to solve the problem of always saving a copy when saving a file in excel.

Hello dear, if you always save a copy when using excel to save a file, this is because the "always create backup copy" option is enabled in excel settings. This can be solved by following these steps:1

Open the Excel software and click on the "File" menu. 2.Select "Options" in the drop-down menu.

3.In the dialog box that appears, select the Save tab. 4.

Untick the "Always create backup copies" option. 5.Click the "OK" button to save the changes.

Extended content: Always saving a copy when Excel saves a file leads to redundant files, takes up more storage space, and is not easy to manage and maintain. Therefore, it is very important to solve the problem of saving a copy of excel in time.

In addition to removing the "Always create a backup copy" option by following the steps above, you can also take the following steps to avoid or reduce the situation of saving a copy:1Regularly clean up filesRegularly clean up unnecessary data and content in excel files, delete redundant worksheets and charts, etc., can effectively reduce the file size and avoid saving copies.

2.Using a good file naming convention to use meaningful file names and folder structure to avoid duplicate names and confusion can effectively prevent copy-keeping. 3.

Use a cloud storage service to save excel files in the cloud, which can be accessed anytime and anywhere, and avoid saving copies due to insufficient local storage space. I'm glad to answer for you, and I hope I can help you. If my answer is helpful to you, please give a like, look forward to your like, your work is very important to me, and your support is also the driving force for my progress.

Best wishes again good health and a good mood!