Recover Excel 2000 Files from Virus-Infected Pen Drives for Free | Stellar

Recover Excel 2000 Files from Virus-Infected Pen Drives for Free | Stellar

Vivienne Lv12

Recover Excel Files from Virus-Infected Pen Drives for Free

Summary: Imagine you lost your important Excel file on which you had been working since the morning and in the next moment you realized that the file was not saved and you just lost hours of work. Wondering how to deal with this situation? Read this blog to know how Stellar free data recovery software can help you.

Free Download for Windows

From making annual reports to business growth representation figures, excel is a commonly used program for organizing data, creating pivot tables, charts etc. People from all walks of life, know the importance of Excel and the part it plays. Although it is a common file, there is a probability that you may accidentally delete excel files while working or are unable to access it due to unexpected errors. In addition, one of the major issues users face is to recover excel files from a virus infected pen drive.

Pen drives have made it possible to store and carry our important files such as excel, word document, photos, videos, etc. with us day in and day out. They just fit perfectly in our pockets and are compatible with almost every device; hence, they are widely used for transferring data from one system to another. But what if your pen drive is infected by a virus and due to it you end up losing your excel files, how will you recover your excel files for free?

A user reported that his pen drive got virus-infected and to remove the virus from it, he ran an antivirus program which removed the virus but also deleted excel files stored on it.

When your pen drive is infected by a virus, the first thing you ought to do is stop using it, even not for removing virus as an antivirus utility may remove your files as well. Further, if you have a backup, then you can recover your excel files from it, else you can use these free data recovery methods to recover your excel files.

1. Free File Recovery Software Approach

Stellar Windows Data Recovery – Free Edition is an easy to use tool to recover files from a virus-infected pen drive. The software is equipped with powerful utilities to recover lost and deleted files for free. Further, it supports a wide range of file systems and is efficient in recovering files such as Excel, emails, word files, photos, audio and video files.

Using Stellar Windows Data Recovery – Free Edition, you can recover your files from all storage devices for free. Here’s how the software works:

  • From the website, download Stellar Windows Data Recovery – Free Edition. Connect your pen drive to your system and launch the software
  • On ‘Select What to Recover’ screen, select file types from the given option that you wish to recover. For instance, if you want to recover photos, then under Multimedia Files, select ‘Photos’ and click on ‘Next

Stellar

  • From ‘Select Location’ screen, select the connected pen drive and click ‘Scan

Stellar

  • The scanning process starts and once the process is complete, software lists all the recoverable files

Stellar

  • Select the files from the list and click on ‘Recover’ to save the files

2. Restore Excel File from the Previous Version

If excel files are deleted from your pen drive or from your system; then you can recover them from the previous version. This feature works when Windows Backup option is enabled, else, it will not work.

Follow these steps to recover excel files:

  • Connect your pen drive to your system, go to This PC and navigate to the folder of excel files
  • Select the folder, right-click on it and select ‘Restore previous versions’
  • From the available version of excel files, select the required one and click on ‘Restore’

3. Use Command Line to Recover Excel Files

The Command prompt should be your first choice to recover excel files from the virus-infected pen drive. Here’s how command prompt recovers your files:

  • Connect your virus-infected pen drive to your system and then in the search box type ‘CMD’ and hit ‘Enter’
  • In the command window, type in attrib –h-r-s /s/ drive letter:\*.*”, for example, “attrib -h -r -s /s /d G:\*.*” and hit ‘Enter’

attrib command

  • Windows starts repairing the virus-infected pen drive and once the process is complete, you can access your pen drive and recover excel files.

Even after following the above-mentioned steps you’re unable to recover your excel files, then try a Home approach i.e. a data recovery tool.

To Sum Up

It is always a good idea to create a backup of important files since no one can anticipate what might go wrong. The scenario presented in the blog paints a clear picture of how you can recover your Microsoft excel files for free from a virus-infected pen drive. For quick and better results, you can always go with Stellar Windows Data Recovery – Free Edition.

[Fixed] “Microsoft Excel Cannot Access the File” Error

Summary: The “Microsoft Excel cannot access the file” error usually occurs when there is an issue with the Excel file you are trying to save. This post summarizes the causes behind the error and mentions some effective solutions to fix it. If you suspect the problem is encountered due to corruption in the Excel file, you can use the professional Excel repair tool mentioned in the post to repair the file.

Free Download for Windows

You may experience the “Microsoft Excel cannot access the file” error when saving the Excel file. This happens when the Excel application fails to read the file you are attempting to save. The error message indicates that there is an issue with the file name or its path. Sometimes, the error occurs if the file you are trying to access is already in use by another application. Some other reasons for the “Excel cannot access the file” error are:

  • Faulty or incompatible Excel add-ins.
  • The file is in Protected View.
  • The Excel file is damaged or corrupted.
  • You do not have the required permissions to access the file.
  • The Excel file is not in a compatible format.

Methods to Fix “Microsoft Excel Cannot Access the File” Error

Sometimes, changing the file location can fix the “Microsoft Excel cannot access the file” error. You can try changing the file location, if the location is incorrect. If moving the file to a different location didn’t work, then try the below troubleshooting methods.

Method 1: Check the File Name and Path

You can get the “Microsoft Excel cannot access file” error if there is an issue with the file path – either the path does not exist or it is too lengthy, thus creating conflicts. Make sure the file path is correct. If the file name is too long, you can rename the file with a short name and also move the file to the parent folder instead of a subfolder. After that, remove the file from the Recent list that is created by Excel based on your recent activity. Follow the below steps:

  • Open the Excel application.
  • In the Recent list, right-click on the affected Excel file.
  • Now, select Remove from list.

Selecting the "remove from list" option

  • Close the Excel application.

Now, reopen the problematic file and check if the error exists. If yes, then follow the next solution.

Method 2: Try Clearing the Microsoft Office Cache

Sometimes, clearing the Microsoft Office cache can help eliminate the “Excel cannot access the file” error. To clear the Microsoft Office cache, follow the given steps:

  • First, close all the Office applications.
  • Press Windows+R to open the Run window.
  • Type %localappdata%\Microsoft\Office\16.0\OfficeFileCache and press the Enter key. You can change ‘16.0’ with your Office version.

Clearing Microsoft Cache from officefilecache Window

  • In the OfficeFileCache window, clear all the temporary files.

Method 3: Check and Update Microsoft Excel

You can try updating your Microsoft Excel application. The latest updates include bug fixes, security patches, and other improvements. Updating the application can help fix several issues that might be causing the error. Here are the steps to update Microsoft Excel:

  • Open your Excel application.
  • Go to File and then select Account.
  • Under Product information, click Update Options and then click Update Now.

Method 4: Disable Protected View

You may get the “Microsoft Excel cannot access the file” error if the Protected View option is enabled. You can try disabling the Protected View settings in Excel. This allows you to open the file without any restrictions. However, disabling the protected view can put your system at high risk. To disable the Protected View in Microsoft Excel, follow the below steps:

  • In Excel, go to File and then click Options.
  • In the Excel Options window, click Trust Center and then click Trust Center Settings.

Go To Trust Center and Click on Trust Center Settings

  • Click Protected View from the left pane in the Trust Center Settings window.
  • Unselect the options under Protected View. Click OK.

Method 5: Check and Disable Add-ins

The “Excel cannot access the file” error can also occur due to faulty add-ins in Excel. To check if the error has occurred due to some faulty add-ins, open the application in safe mode (press Windows + R and typeexcel /safe in the Run window**)**. If you can save the file without any hiccups in safe mode, this indicates some problematic add-ins are behind the error. You can remove the Excel add-ins by following these steps:

  • Open your Excel application and go to File > Options.

  • In Excel Options, select Trust Center and then click Trust Center Settings.

  • In Trust Center Settings, click Add-ins and thenselect “Disable all applications Add-ins”. Click OK.

Go to 'Add ins' and select disable all application add ins

Method 6: Check File Permission

You can get the “Excel cannot access the file” error if you don’t have sufficient permissions to modify the Excel file. You can check and provide the write permissions to fix the issue. Here’s how to do so:

  • Open Windows Explorer.
  • Find the affected Excel file, right-click on it, and click Properties.

Click Properties Option

  • In the Properties window, click the Securities option and click Edit.

Go to Security and then click Edit option

  • In the Security window, select the user names under ‘Group or users name’.
  • Check the file permissions and make sure the write option is enabled. If not, then grant the permission. Click Apply and then OK.

The “Excel cannot access the file” error can also occur due to broken external links in the Excel file. External links are references to the data or content in other files. The link usually breaks if the file has been moved to another location or the file name is changed. You can check and change the source of link.

Method 8: Repair your Excel File

Excel may fail to read the file if it is corrupted or damaged. If the error “Excel cannot access the file” has occurred due to file corruption, then try the Excel’s Open and Repair utility to repair the Excel file. Here are the steps:

  • In the Excel application, click the File tab and then select Open.
  • Click Browse to select the problematic workbook.
  • The Open dialog box will appear. Click on the corrupted file.
  • Click the arrow next to the Open button and then select Open and Repair.
  • You will see a dialog box with three buttons – Repair, Extract Data, and Cancel.

Click repair option

  • Click on the Repair button to recover as much of the data as possible.
  • After repair, a message is displayed. Click Close.

If the Open and Repair utility fails to work , it indicates the Excel file is severely corrupted. Use Stellar Repair for Excel to repair severely corrupt Excel file. It helps recover all the components of the corrupted Excel file, such as charts, formulas, etc. without making any changes to the original file. It can also fix all types of corruption-related errors. You can use Stellar Repair for Excel to repair Excel files created in all Excel versions – from 2007 to 2023.

Closure

The “Microsoft Excel cannot access the file” error can occur due to numerous reasons. Follow the troubleshooting methods, such as checking file location, path, permissions, etc., as discussed above to fix this error. Sometimes, Excel throws this error if the file you are trying to save is corrupted. You can try repairing the file using the built-in utility – Open and Repair. If the file is severely corrupted, then you can use Stellar Repair for Excel . It can repair damaged Excel files (.xls, .xlsx, .xltm, .xltx, and .xlsm) with complete integrity.

How to fix Microsoft Excel has stopped working error?

Summary: This blog discusses the possible reasons behind ‘Microsoft Excel has stopped working’ error and solutions to resolve the error manually. You can use Stellar Repair for Excel to quickly repair the file and recover all its data in a hassle-free manner.

Free Download for Windows

Has your Microsoft Excel program stopped working or is acting strange? Excel not responding is a common issue you may experience on launching the application or opening a spreadsheet.

Microsoft Excel has stopped working

Figure 1 – Microsoft Excel Has Stopped Working Error Message

Possible Causes behind ‘Microsoft Excel has Stopped Working’ Error, and Solutions Thereof

Note: Several users have reported about encountering the ‘Excel has stopped working’ issue on Windows 10, 8, and 7 OS after installing an update for Excel (KB3118373). If you too have installed the update, then uninstall it and check if it solves the error. For detailed information, refer to this link .

How Do I Restore Excel File ?

Excel (XLS/XLSX) file corruption is a common issue that may arise due to problems, such as abrupt system shutdown, system crash, malware or virus intrusion, unsupported add-in, etc. However, MS Excel comes with a recovery feature that allows users to recover or restore Excel files lost or corrupted when the MS Excel quits unexpectedly or computer crashes due to hardware or software-related issues.

But sometimes, the restored version of the Excel file may not contain all the data or changes you made recently. In such cases, you are left with the option to repair the damaged or corrupt Excel file with the help of an Excel repair software, such as Stellar Repair for Excel .

Solutions to Restore Excel File

Below we have discussed various solutions to repair, recover, and restore unsaved, lost, corrupt, or inaccessible Excel files with the help of MS Excel options and Excel repair software.

NOTE: Some of these methods work only if you had enabled or configured certain required settings or options before corruption or losing the Excel file.

1. Restore Lost or Unsaved Excel File via ‘Recover Unsaved Workbooks’ Option

The Recover Unsaved Workbooks option allows you to restore the Excel file that you forgot to save before closing MS Excel or it stopped working. The steps are as follows:

  • Navigate to ‘_File > Open._’
  • Scroll to the bottom and click on ‘Recover Unsaved Workbooks.’ This opens a File Explorer browser window.

recover unsaved excel file

  • Now look for the Excel file that you lost and then double-click on it to open and restore the Excel file.
  • Once the file is open, click on File > Save As and save it to your desired location.

However, this option works only if you had enabled and set up the ‘Save AutoRecover information every X minutes_’ option and enabled the ‘_Keep the last AutoRecovered version if I close without saving’ option.  

change excel settings

Also, this may not restore the most recent copy of your Excel file, but it will surely save your time that went into creating and editing the workbook.

2. Repair and Restore Corrupt or Inaccessible Excel File

If the Excel file you are trying to open or access is corrupt, MS Excel will display an error message. When MS Excel detects corruption, it starts ‘File Recovery Mode’ to repair the Excel workbook.

However, if it doesn’t start automatically, you can manually repair minor corruption error and restore the Excel file by following these steps:

  • Navigate to File > Open and then navigate to the corrupt or damaged Excel file location.
  • Select the file and then click on the arrow beside the ‘Open’ button to choose the ‘Open and Repair…’ option.

open and repair excel file

  • Now click ‘Repair’ if you want to recover maximum data from a corrupt or inaccessible Excel workbook and restore it to a new Excel file.

repair corrupt excel file

If the ‘Repair’ option fails, use the Extract Data option that extracts values, data, and formulas from the Excel workbook.

3. Revert Excel File to Last Saved Version

When an Excel file gets corrupt or damaged while working, you may revert the Excel file to the last saved version. This allows you to restore the Excel file version that isn’t corrupt or damaged. The steps are as follows,

  • Click File > Open.
  • Double-click the name of the workbook that you have opened in Excel.
  • Click Yes to reopen the workbook.

The workbook opens without any changes you’ve made that might have caused the workbook to become corrupted.

4. Use Excel Repair Software to Restore Excel File

If the corrupt or damaged Excel file isn’t repaired by using MS Excel options or you lost data after restoring the unsaved version or after reverting to the last version, you can rely on an Excel repair software, such as Stellar Repair for Excel.

The software repairs Excel files with 100% integrity and restores the Excel data, such as table, Pivot tables, charts, etc., while preserving the workbook properties and formatting. The software is safe as it doesn’t alter or make changes to the original Excel file and saves the repaired data to a new Excel workbook at your desired location.

It supports Excel files (XLS and XLSX), created in MS Excel 2019, 2016, or older versions. It resolves Excel corruption errors, such as Unable to open Excel file, in a few clicks.

To repair a corrupt or inaccessible Excel workbook by using Stellar Repair for Excel software, follow these 3 simple steps,

  • Select the corrupt or damaged Excel workbook file (XLS/XLSX).

stellar repair for excel

  • Repair and then preview the Excel workbook.

repaired excel file

  • Save the workbook at default or your desired location.

save repaired excel file

Once saved, you can open and start editing or working on the Excel sheet. Make sure to enable AutoRecovery and AutoSave options to avoid data loss due to corruption.

Conclusion

In this article, we discussed methods and solutions to restore Excel file when it gets damaged or corrupt due to various issues. Although Excel can help you recover or restore Excel file after corruption, it can resolve only minor corruption errors. Thus, it may fail if the Excel file corruption is severe. In such cases, an Excel repair software, such as Stellar Repair for Excel, comes in handy. It resolves Excel corruption, repairs tables, charts, chart sheets, Pivot table, etc., and restores them to a new Excel sheet with 100% consistency.

[Fix] Excel formula not showing result

Summary: Is your Excel spreadsheet showing text of a formula you’ve entered and not its result? This blog explains the possible reasons behind such an issue. Also, it describes solutions to fix the ‘Excel formula not showing result’ error. You can try Stellar Repair for Excel software to recover engineering and shared formulas.

Free Download for Windows

Sometimes, when you type a formula in a cell of worksheet and press Enter, instead of showing the calculated result, it returns the formula as text. For instance, Excel cell shows:

Excel not Showing Formula

But you should get the result as:

Excel Formula Working Sample

Why Does Excel Show or Display the Formula Not the Result?

Following are the possible reasons that may lead to the ‘Excel showing formula not result’ issue:

  1. You accidentally enabled “Show Formulas” in Excel.
  2. The cell format in a spreadsheet is set to text.
  3. ‘Automatic calculation’ feature in Excel is set to manual.
  4. Excel thinks your formula is text (Syntax are not followed).
  5. You type numbers in a cell with unnecessary formatting.

How to Fix ‘Excel Showing Formula Not Result’ Issue?

Solution 1 – Disable Show Formulas

If only the formula shows in Excel not result, check if you have accidentally or intentionally enabled ‘show formula’ feature of Excel. Instead of applying calculations and then showing results, this feature displays the actual text written by you.

You can use the ‘Show Formulas’ feature to quickly view all formulas, but if you are not aware of this feature, and enabled it accidentally, it can be a headache. To disable this mode, go to ‘Formulas’ and click on ‘Show formula enabled.’ If it’s previously enabled, it will be disabled by just clicking on it.

Show Formula Enabled

Solution 2 – Cell Format Set to Text

Another possible reason that only formula shows in Excel not result could be that the cell format is set to text. This means that anything written in any format in that cell will be treated as regular text. If so, change the format to General or any other. To get Excel to recognize the change in the format, you may need to enter cell edit mode by clicking into the formula bar or just press F2.

Enter Cell Edit Mode by Clicking into the Formula Bar

Solution 3 – Change Calculation Options from ‘Manual’ to ‘Automatic’

There is an “automatic calculation” feature in Excel, which tells Excel to do calculations automatically or manually. If ‘Excel formula is not showing results’, it may be because the automatic calculations feature is set to manual. This issue is not easily detected because it results in calculating formula in one cell but if you copy it to some other cell, it will retain the first calculation and will not recalculate on the base of the new location. To fix this, follow these steps:

  • In Excel, click on the ‘File’ tab on the top left corner of the screen.
  • In the window that opens, click on ‘Options’ from the left menu bar.
  • From ‘Excel Options’ dialog box, select ‘Formulas’ from the left side menu and then change the ‘Calculation options’ to ‘Automatic’ if it’s currently set as ‘Manual’.

Automatic Calculations Feature

  • Click on ‘OK’. This will redirect you to your sheet.

Solution 4 – Type Formula in the Right Format

There is a proper way to tell Excel that your text is a formula. If you don’t write the formula in a particular format, Excel considers it as simple text and hence no calculations are performed according to it. For this reason, keep the following in mind when typing a formula:

  • Equal sign: Every formula in Excel should start with an equal sign (=). If you miss it, Excel will mistake your formula as regular text.

  • Space before equal sign: You are not supposed to enter any space before equal sign. Maybe a single space will be hard for us to detect, but it breaks the rule of writing formulas for Excel.

  • Formula wrapped in quotes: You need to make sure that your formula is not wrapped in quotes. People usually make this mistake of writing a formula in quotes, but in Excel, quotes are used to signify text. So your formula won’t be evaluated. But you can add quotes inside formula if required, for example: =SUMIFS(F5:F9,G5:G9,”>30″).

  • Match all parentheses in a formula: Arguments of Excel functions are entered in parenthesis. In complex cases, you may need to enter more sets of parenthesis. If those parentheses are not paired/closed properly, Excel may not be able to evaluate the entered formula.

  • Nesting limit: If you are nesting two or more Excel functions into each other, for example using nested IF loop, remember the following rules:

    • Excel 2019, 2016, 2013, 2010, and 2007 versions only allow to use up to 64 nested functions.
    • Excel 2003 and lower versions only allow up to 7 nested functions.

Solution 5 – Enter Numbers without any Formatting

When you use a number in the formula, make sure you don’t enter any decimal separator or currency sign, e.g. $, etc. In an Excel formula, a comma is used to separate arguments of a function and a dollar sign makes an absolute cell reference. Most of these special characters have built-in functions so avoid using them unnecessarily.

What to Do If the Manual Solutions Don’t Work?

If you’ve tried out the manual solutions mentioned above but still unable to resolve the ‘Excel formula not showing result’ issue, you can try repairing your Excel file with the help of an automated Excel repair software , such as Stellar Repair for Excel.

This reliable and competent software scans and repairs Excel files (.XLSX and .XLS). It also helps recover all the file components, like formulas, cell formatting, etc. Armed with an interactive GUI, this software is extremely easy to work with, and its advanced algorithms allow it to fend off Excel errors with ease.

Free Download for windows

Conclusion

This blog outlined the possible reasons that may cause ‘Excel not showing formula results’ issue. Check out these reasons and implement the manual fixes, depending on what resulted in the problem in the first place. If none of these fixes help resolve the issue, corruption in the Excel file might be preventing the formulas from showing the actual results. In that case, using Stellar Repair for Excel tool might help.

How to Repair Corrupted or Damaged Excel File with Ease?

Summary: The Excel file is prone to corruption. Users can face several issues related to corruption. So here in this infographic, I am discussing a professional tool,- Stellar Repair for Excel, to easily repair corrupted Excel files.

Free Download for Windows

Stellar Repair for Excel is among the top choices for repairing corrupt or damaged Excel (.XLS/.XLSX) files. This Excel recovery software restores everything from the corrupt file to a new blank Excel file. Incoming, the information graphics complete overview of the repair process is explained in step-by-step methodology. Explore and reap the benefits of recovering corrupt or damaged Excel files.

Repair Corrupt Excel Files Infographic

Very much sure about the result of using the excel file recovery tool, share your experience with us.

Solutions to open Excel Read Only Documents

‘Excel cannot open read-only documents’ is an error message that usually appears when you try to open an Excel (XLS or XLSX) file downloaded from the Internet, email, or the network server. It may also appear when you try to open an encrypted or password-protected Excel document. In such a case, MS Excel prevents the user from making any changes to the document.

error message

Reasons behind the “Excel cannot access ‘xxx.xls.’ The Document may be read-only or encrypted” Error

There could be several reasons that may cause the error. Some of them are as follows:

  • Corrupt or damaged Excel workbook
  • Incompatible or unsupported add-in
  • Antivirus or malware software conflict
  • Read-Only Excel file
  • The file is encrypted
  • File or drive read/write permissions issues
  • Protected Excel workbook
  • Damaged or missing MS Office (MS Excel) program files

Solutions to Open and Edit Read-Only Excel Documents

Below are a few solutions that can help you fix the ‘Excel cannot access ‘xxx.xls.’ The Document may be read-only or encrypted’ error and allow you to open and edit Excel documents.

  • Remove Read-only Attribute from Excel File Properties

The ‘Excel cannot open read-only documents’ error message may appear when the Excel file property is set to read-only. To check if this is the case, follow these steps:

  • Right-click on the particular Excel (xls/xlsx) document and select ‘Properties’.
    • Uncheck the ‘Read-only’ attribute and then click the ‘OK’ button.

Illustrates the 'Read-only' attribute in Excel XLSX document

Now try to open the Excel document and check if the problem is fixed.

  • Adjust Antivirus Settings

A few antivirus programs block Excel files and other Office documents by opening those in ‘read-only’ mode. In such cases, try adjusting the antivirus settings to open the Excel files normally. This will allow you to edit, modify, and save the Excel workbook without encountering the “Excel cannot access ‘xxx.xls.’ The Document may be a read-only or encrypted” error message.

  • Disable Protected-View

The error may appear when you try to open an Excel file received as email attachments or downloaded from unsafe source. The file may potentially contain viruses, worms, or other types of malware that could damage the system or the server.

To safeguard the system, MS Excel opens such files in Protected View. It may also open an Excel workbook in Protected Mode when it detects a problem with the file. This security feature allows you to read or view Excel files and reduces the risks to the computer system or PC.

However, you can click File > Info and then click ‘Edit Anyway‘ to access and edit file content. You may also disable the Protected View setting via File > Options > Trust Center > Trust Center Settings…> Protected View. However, we do not recommend this.

Protected View

  • Renew/Activate Microsoft Office

If MS Office is in a deactivated state or its subscription has expired, the Office documents, including the Excel, could be in ‘read-only reduced functionality mode.’

In such a scenario, activate Microsoft Office or renew the Office subscription. Then open the Excel workbook and check if the problem of ‘Excel cannot open read-only documents’ is resolved.

  • Check if OneDrive Storage is Full

If Excel files are saved on OneDrive with low or no storage space, you may encounter such issues with your files.

To know the amount of free space on OneDrive, follow these steps:

  • On your PC, open Settings and navigate to OneDrive.
    • Click ‘Sync Settings > File Storage‘ to see available space.

You may also visit onedrive.live.com, sign in to the account, and then check the available space. If there’s no space available or the drive is full, empty the storage space and see if the problem is resolved.

  • Check and Update MS Office and Windows

Microsoft releases updates to fix known errors. Thus, it is critical to update both Windows and MS Office to the latest release and avoid issues, such as ‘Excel cannot access ‘xxx.xls.’ The Document may be read-only or encrypted.’

  • Repair MS Office (MS Excel)

The error ‘Excel cannot open read-only documents’ may appear due to a problem with your MS Office (MS Excel) program. You can repair the MS Office program to resolve such errors. The steps are as follows:

  • Open Control Panel and click Uninstall a Program link under Programs.
  • Choose Microsoft Office from the list and click the Change button.

Change button

  • Select Quick Repair and then click Repair to fix problems with MS Office and MS Excel. It will also restore any missing or damaged program files.

Quick Repair and then click Repair to fix problems

After the Repair, open the Excel workbook and check if the error is resolved.

  • Check Permissions

The error message may also appear if you access an Excel workbook from a network or shared drive due to lack of write permission. Make sure you have read and write permissions assigned for the particular network drive. Alternatively, you can copy the file from the network drive and save it in your local folder to access and edit it without encountering this error message.

  • Repair MS Excel File

If none of the solutions worked, the Excel workbook could be damaged or corrupt. To repair such damaged Excel workbook or spreadsheet, you can use the inbuilt ‘Open and Repair…’ option in MS Excel or install an Excel repair software , such as Stellar Repair for Excel. The software comes in handy when the Open and Repair option fails to fix the Excel workbook problems. It repairs the corrupt or damaged Excel workbook, extracts all components and content from the file with 100% integrity, and saves them in a new Excel workbook.

Conclusion

Sometimes, the ‘Excel cannot open read-only documents’ error can be resolved by a simple restart. But if it doesn’t work, you can follow the solutions discussed in this article to resolve the ‘Excel cannot open read-only documents’ issue.  However, if the issue is caused due to a damaged or corrupt Excel workbook, these methods may not work. In such a case, you can use Excel’s inbuilt repair utility, i.e., Open and Repair, or install Stellar Repair for Excel software recommended by MVPs and industry experts to fix all kinds of problems with MS Excel workbooks.


  • Title: Recover Excel 2000 Files from Virus-Infected Pen Drives for Free | Stellar
  • Author: Vivienne
  • Created at : 2024-03-13 22:19:38
  • Updated at : 2024-03-14 23:37:23
  • Link: https://review-topics.techidaily.com/recover-excel-2000-files-from-virus-infected-pen-drives-for-free-stellar-by-stellar-guide/
  • License: This work is licensed under CC BY-NC-SA 4.0.
On this page
Recover Excel 2000 Files from Virus-Infected Pen Drives for Free | Stellar