CARA MENGATASI EXCEL RESTORE FILE

Have you ever experienced difficulties when trying to save an Excel file? It can be frustrating, especially if you have been working on the file for hours. Don’t worry, in this article, we will discuss how to solve the problem of Excel files that cannot be saved, opened, or edited.

Problem

There are several reasons why an Excel file cannot be saved. The most common reasons are:

• File in use by another program.
• File is read-only.
• File is located on a read-only network location.
• Incorrect file permissions.
• File is corrupted.

Solutions

1. File in use by another program

If Excel cannot save the file because it is being used by another program, you need to identify the program that is using the file and close it. To do this, follow these steps:

1. Open Excel and try to save the file again.
2. If you receive an error message that says the file is in use by another program, click “OK”.
3. Open Resource Monitor by typing “resmon” into the Start menu and pressing Enter.
4. Select the “CPU” tab and look for any programs that are using a high percentage of CPU.
5. Select the “Disk” tab and look for any programs that are using a high number of disk I/O.
6. Once you have identified the program that is using the file, close it and try to save the Excel file again.

2. File is read-only

If the Excel file is read-only, you need to change its attributes to enable editing. Here’s how:

1. Right-click on the file and select “Properties”.
2. Uncheck the “Read-only” option and click “OK”.
3. Try to save the Excel file again.

3. File is located on a read-only network location

If the file is located on a network location that is marked as read-only, you will not be able to save the Excel file. To fix this, you need to move the file to a different location.

4. Incorrect file permissions

If you do not have the correct file permissions, you will not be able to save the Excel file. To fix this, you need to change the file permissions. Here’s how:

1. Right-click on the file and select “Properties”.
2. Select the “Security” tab and click “Edit”.
3. Click “Add” and enter your username.
4. Select your username and check the “Full control” option.
5. Click “Apply” and “OK”.
6. Try to save the Excel file again.

5. File is corrupted

If the file is corrupted, you may not be able to save it. Here’s how to fix it:

1. Open Excel and click “File” > “Open”.
2. Select the corrupted file and click the arrow next to “Open”.
3. Select “Open and Repair”.
4. Try to save the Excel file again.

FAQs

1. Why can’t I save my Excel file?

There are several reasons why you cannot save your Excel file, including file in use by another program, file is read-only, file is located on a read-only network location, incorrect file permissions, and corrupted file. You can try the solutions mentioned above to fix the problem.

2. What should I do if the Excel file is still not saving?

If the solutions mentioned above do not work, you can try the following:

1. Try to save the file with a different name.
2. Copy the file contents to a new Excel file and try to save it.
3. Try to save the file in a different format (e.g. CSV, TXT).

If you are still unable to save the Excel file, you can contact Microsoft support for further assistance.

Video Tutorial