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.

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’

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

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

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’

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] The Workbook Cannot Be Opened or Repaired By Microsoft Excel

An MS Excel workbook (.XLS/.XLSX) file may not open due to damage or corruption caused by various reasons, such as:

Sudden power failure
System crash
Virus or malware intrusion
Large or oversized Excel file
Incompatible add-ins
Drive errors
Damaged MS Office/Excel program files

As a result, when you try to open or access a corrupt Excel document, the program displays errors, such as “The workbook cannot be opened or repaired by Microsoft Excel because it is corrupt.” This may lead to a data loss situation.

Methods to Fix ‘The Workbook Cannot Be Opened’ Error

When an Excel workbook gets corrupt, MS Excel automatically detects and starts the file recovery mode to open and repair the file. However, when it fails to repair the corruption or recover the Excel file automatically, it displays the error message, “The workbook cannot be opened or repaired by Microsoft Excel because it is corrupt.” In such a situation, you can follow these methods to repair and recover the Excel document manually.

If the manual methods fail to resolve the error, you can use an Excel repair software, such as Stellar Repair for Excel. The software repairs corrupt XLS/XLSX file, recovers all the data, and saves it in a new Excel document with 100% precision, while keeping the cell formatting and properties intact.

NOTE: Before performing the below methods to repair or recover Excel documents, create a backup copy of the original file. This will help you recover data by using an Excel repair tool and avoid permanent data loss.

1. Repair Excel Workbook Manually

If the automatic repair fails, you may try manual repair to fix the damage or extract the data from the damaged Excel workbook. The steps are as follows:

Navigate to File > Open and then go to the location where the spreadsheet is located.
In the Open window, select the corrupted workbook that you want to fix and then click on the arrow next to the Open button.
From the available options, choose Open and Repair…

Then click ‘Repair‘ if you want to recover maximum data from the workbook or click ‘Extract data‘ if the repair option fails to fix the issue. It will extract all the values, formulas, tables, etc., from the corrupt workbook.

If both options fail to fix the issue, head to the next method.

2. Remove Faulty or Incompatible Add-ins

Faulty or incompatible add-ins may also cause this error. To find and remove such add-ins, follow these steps:

Press **Windows key + R.
**

Type Excel /safe and press ‘Enter‘ or click ‘OK.’ This opens MS Excel in Safe Mode.
Go to File > Options and then select ‘Add-ins.‘

Choose ‘Excel Add-ins‘ from Manage: option and then click on the Go button to view all Add-ins.

Uncheck the checkboxes of Add-ins and then click ‘OK‘ to disable them.

Now close the Excel program and run it normally. Click ‘File > Open‘ and choose the Excel file you want to access.

3. Repair MS Office Installation

Damaged Excel program files may also lead to such errors. However, you can easily repair MS Office installation to fix the problem. The steps are as follows:

Open Control Panel and select ‘Uninstall a program.‘

Search and choose MS Office from the programs list. Then click on the ‘Change’ button.

Select ‘Repair’ and follow the wizard to fix the damaged program files.

If this fails to address the issue, you can uninstall and then fresh install MS Office on your system. Alternatively, try accessing the file on another PC.

4. Use Excel Repair Software

The best option is to use an Excel repair software, such as Stellar Repair for Excel , to repair the file, resolve the error, and access the Excel (XLS/XLSX) worksheet. The software can repair an Excel file without any size limitation.

After recovering the Excel file using the software, you can open it in any MS Excel program without encountering the error message.

Conclusion

A corrupt or damaged Excel workbook may lead to errors, such as “The workbook cannot be opened or repaired by Microsoft Excel because it is corrupt,” and cause a data loss situation. The most efficient way to fix such corrupt Excel files is to repair them by using an Excel repair tool, such as Stellar Repair for Excel.

Unlike manual methods that may fail to resolve the issue or lead to further damage, this software extracts the data from the damaged Excel file and saves it in a new Excel workbook. Thus, it is 100% safe to run on an original Excel file, as it does not overwrite or alter the original file.

The software is free to download. You can scan, repair, and preview a corrupt Excel file by using the demo version. Once you are satisfied with the results, activate the software to save the repaired Excel workbook data in a new sheet.

Fix Cannot Paste the Data Error in Microsoft Excel

When copying and pasting the cell contents or attributes from one workbook to another, you can encounter the “Cannot paste the data” error. The error indicates that the values you are trying to paste do not match the cell format (Currency, Date, Text, etc.) used in the column. The error can occur if you are attempting to paste information into a merged cell. You can also get this error if the data you are trying to paste contains more columns than the destination worksheet can accept or if the copy area and paste area aren’t the same size.

Why you cannot Paste the Data in Microsoft Excel?

You can experience the “Excel cannot paste the data” error due to one of the following reasons:

Locked cells
Data size limitation
Formatting issues
The file size is too large
Overloaded clipboard
Data type mismatch
Invalid range
Lack of permissions
Excel file is corrupted
Compatibility issues
While pasting the merged cells

Methods to Fix MS Excel Cannot Paste the Data Error

The “Microsoft Excel cannot paste the data” error usually appears when copying and pasting data within the spreadsheet. It primarily affects the copy-and-paste feature within the Excel file. However, the impact of this error may vary with the data you are working with. When this error occurs, first try restarting the Excel application. Ensure that you’ve saved all your important data before restarting the application to prevent data loss. If, after performing this basic step, you still face the issue, then try the following troubleshooting methods.

Method 1: Check and Unlock Cells in Excel

You can get the Excel cannot paste the data error if the cells you are trying to paste in the Excel file are locked. You can check and unlock the specific cells in the Excel file using the below steps:

Go to the Home tab in your Excel file and click Format Cell Font popup launcher.

In the Format Cells dialog box, click Protection.

Under the Protection option, unselect the locked field and then click OK.

Method 2: Check and Fix the Cell Format

Sometimes, you can get the “Cannot paste the data” error in Excel if there is an issue with the formatting of the cells in the column (in which you are trying to paste the data). You can check whether the cell formats of the columns of the source file (from where you are copying data) match the destination file (in which you are pasting the cell data). If not, then change the cell format. Here’s how to do so:

In the Excel file, click on the affected column heading (whose cells you need to modify).
Navigate to the Home tab and click the General dropdown menu.

Click on the desired cell format that matches the values you are trying to paste into the column.

Method 3: Check Copy and Paste Area Size

The “data cannot be pasted” issue can also occur if Excel detects the copy area of the range of cells is not of the same size and shape as that of the paste area. So, make sure the size of the range of cells for the paste area is same as the copied area. To ensure this, you can try the following:

Use Upper-left Cell

You can select the upper-left cell instead of the complete range to paste.

Use Paste Special Option
You can use the Paste Special option to paste the data. To use this option, go to Home > Paste Special.

You can choose from the different options, such as paste all, formulas, operations, Transpose, skip blanks, etc. to take control over how the data is pasted.

Method 4: Check and Unmerge Cells

The merged cells in the workbook can create discrepancies when copying and pasting data. These can create mismatch between the source and destination cell areas, resulting in errors. Make sure you are not pasting the data copied from merged cells. You can check and unmerge the cells using the below steps:

Open the Excel file (in which you are copying data) and go to the Home tab.
Click Merge & Center > Unmerge Cells.

Method 5: Unselect the Excel DDE (Dynamic Data Exchange) Option

Sometimes, you can get the Excel cannot paste the data error while copying and pasting data from Excel file to external data sources or applications. It usually appears if you have established DDE links between them. To resolve this, you can uncheck the “Ignore other applications that use Dynamic Data Exchange (DDE)” option. Follow the below steps to do so:

Open your Excel file.
Go to File > Options.

In Excel Options, click Advanced and unselect “Ignore other applications that use Dynamic Data Exchange (DDE). Click OK.

Here are some additional solutions you can try to fix the “Cannot paste the data” error in Excel

Check the Excel File Format

Sometimes, the copy and paste error can occur if you try to move data from an older version of Excel file (XLS) into a newer version file (XLSX) or vice versa. You can try to change or convert the file format to resolve the issue.

Clear Clipboard

Too many items on the clipboard can prevent you from copying and pasting the data. You can empty your clipboard by deleting all clips. To do this, go to Home and click the Clipboard option.

Change the Column’s Cell Format

You can get the “Cannot paste the data” error when the information you need to paste does not match the cell format in the column. In such a case, you can change the column’s cell format. To do this, navigate to the Home option and then click on the General menu arrow. Then, change the cell format suitable to the type of information you are trying to paste in that column.

Add Columns

The copy-and-paste error in Excel can also occur if there are not enough columns to accept the data that you are trying to paste. You can insert more columns and then try copying and pasting data. To insert additional columns, click on the column heading, click Home, and then select Insert.

Remove Incompatible Add-ins

Sometimes, incompatible or faulty add-ins can also create conflicts with Excel’s clipboard operations, leading to the error. To check if add-ins are causing the issue, open the Excel file in safe mode. In safe mode, if you are able to paste the data, then check and uninstall the incompatible Excel Add-ins.

What to do if Nothing Works?

If the above methods do not work, then corruption in the Excel file could be the cause of the “Cannot paste the data” error. In such a case, you can use Excel’s built-in Open and Repair utility to repair the corrupted file. Here’s how to use this utility to repair the Excel file:

Open your Excel application.
Navigate to File and then click Open.
Click the Browse option to select the affected Excel file.
The Open dialog box opens up. Click on the corrupted file.
From the Open dropdown, select the Open and Repair option.
The Excel will prompt you to choose one of the below options:
Repair
Extract
Cancel
Select the Repair option to extract maximum data from the file. If the Repair option fails, choose the Extract option to recover the data, excluding formulas and values.

The Open and Repair utility may not be able to repair your Excel file if it is severely corrupted. In such a situation, the best possible way out is to use a professional Excel repair software to repair the file. You can try Stellar Repair for Excel. It can repair highly damaged or corrupted Excel (.xls, .xlsx, .xltm, .xltx, or .xlsm) file and recover all the objects from the file by maintaining the original formatting. The tool supports 2007 and higher editions of MS Excel. You can download the demo version of the software to preview the repaired objects and verify its functionality.

Conclusion

The “Excel cannot paste the data” error in Excel can occur due to different factors. You can check and clear the clipboard, unmerge the cells, unlock the cells, and use various other methods mentioned above to troubleshoot the error. If you fail to copy and paste the data due to file corruption, then opt for an advanced Excel repair software, like Stellar Repair for Excel. It is a reliable tool that can help you repair highly damaged/corrupted Excel files. It enables you to recover all the objects from the corrupted Excel file, with complete integrity.

How to Resolve ‘Excel found unreadable content in filename.xlsx’ Error in MS Excel?

When opening an Excel spreadsheet in MS Office 2010/2007, you may get the following error message:

“Excel found unreadable content in ‘[filename].xlsx’. Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes.”

On clicking ‘Yes’, you may face any of these scenarios:

Note: If you choose to click ‘No’, then open your MS Excel application and click file > Open. When the Open dialog box opens, browse and select the file showing the ‘Excel found unreadable content’ error and then choose ‘Open and Repair’ option. If this didn’t help, try using a third-party Excel repair tool to save time troubleshooting the issue and restoring the file with all its data intact.

Scenario 1: The following message may pop-up.

“Excel was able to open the file by repairing or removing the unreadable content. Excel recovered your formulas and cell values, but

some data may have been lost

. Click to view log file listing repairs errorxxx.xml.”

The message clearly states that your Excel file might open, but images may be lost and other such inconsistencies can crop up.

Scenario 2: The error is followed by another error message, like “The file is corrupt and cannot be opened“.

Watch our short video for a quick overview of the solutions to fix “Excel found unreadable content in filename.xlsx”

What Causes ‘Excel Unreadable Content’ Error?

You may encounter the ‘Excel file unreadable content’ error due to corruption of complete Excel file or corruption in certain areas (like Pivot Table, Formulas, Styles, or other objects) in the file. According to Microsoft, you may find it difficult to determine the root cause behind Excel file corruption. Corruption could occur in different scenarios, like power surge, a network glitch, copying and pasting corrupted data from another file, etc.

Also Read: How to recover data from corrupt or damaged Excel file 2010 & 2007?

Workarounds to Resolve the ‘Excel found unreadable content in filename.xls’ Error

There is no permanent solution to fix the ‘Excel found unreadable content’ error. But, following are some workarounds you can try to resolve the error.

Note: Before you try any of these workarounds, run Excel with administrator privileges and try opening the Excel file that is throwing the ‘unreadable content’ error. If this doesn’t fix the error, proceed with the workarounds below.

Workaround 1 – Try Opening the File in Excel 2003

Sometimes a problem in the current Excel version might prevent a file from opening. To resolve this error, try opening the problematic file in Excel 2003. If the file opens, save the data in a web page file format (.html) and then try opening the .html file in MS Excel 2010/2007. The detailed step-wise instructions are as follows:

Open the .xls file in Excel 2003.
When the file opens, click on File > Save.
In the ‘Save As’ dialog box, choose Web Page (.html) as the ‘Save as type’ and then click ‘Save.’ Doing so will save everything from your .xls file, opened with 2003, in .html file format.
Open the .html file in Excel 2010/2007. And then, save the file with .xlsx extension with a new name to avoid overwriting the original file.

Now, open the Excel 2010/2007 file and check if the error is fixed. If not, use the next workaround.

Workaround 2 – Make the Excel File ‘Read-only’

Try to open your ‘.xlsx’ file by making it ‘read-only’. Follow these steps:

In Excel, click ‘File’ from the main menu.
Select ‘Save’ for a new document or ‘Save As’ for a previously saved document in the screen that appears.

From the ‘Save As’ dialog box, click Tools > General Options.

Click on the ‘Read-only recommended’ checkbox to make the document read-only and then click ‘OK’.

Now open a new ‘.xlsx’ file and copy everything from the corrupt Excel file to this new file. Finally, save this file and try to open it again.

Workaround 3 – Move Excel File to a New Folder

Some users have reported that they could open their Excel file, following the ‘Excel unreadable content’ error, by simply moving the file to a different folder and saving it under a new name. You can also move the affected file to a new folder and try opening it. If this didn’t help resolve the error, follow the next workaround.

Workaround 4 – Install Visual Basic Component

At times, it is seen that installing the ‘Visual Basic’ component of MS Office 2010 resolves the ‘Excel found unreadable content 2010’ error. To do so, follow these steps:

Navigate to Control Panel > Programs and select Microsoft Office 2010.
Click ‘Change’ and then select ‘Add or Remove Programs’.
Next, click the ‘plus’ sign provided next to Office Shared Features.
Click ‘Visual Basic for Applications’. After that, right-click and choose ‘Run from My Computer’ and hit the ‘Continue’ button.
Reboot your system when this process finishes.

Now check if the issue has been resolved or not.

What Next?

If none of the workarounds mentioned above works for you, use a professional Excel repair software, such as Stellar Repair for Excel. The software repairs corrupt MS Excel sheets without modifying their original content and formatting. In addition, it can repair single or multiple Excel (XLS/XLSX) files in a few simple steps.

Steps to Repair Corrupt Excel File using Stellar Repair for Excel Software

Install and run Stellar Repair for Excel software.
From the software main interface window, click ‘Browse’ to select the corrupt file. If you are not aware of the corrupt Excel file location, click on the ‘Search’ button.

Click on the ‘Repair’ button to scan and repair the selected file.

A preview window will open with recoverable Excel file data. Once satisfied with the preview result, click on the ‘Save File’ button on the ‘File’ menu to start the repair process.

Select the destination to save the file.

Click ‘OK’ when the ‘Repaired file saved successfully’ message appears.

The repaired Excel file will get saved at the selected location.

‘Unable to Save Excel Workbook’ Issue [Fix 2024]

Summary: You may unable to save your Excel Workbooks due to several reasons. Many users have reported this issue on the Tech Forums. This blog will discuss a few instances when users cannot save their Excel files. It lists the causes behind the issue and their possible solutions. It also mentions the Stellar Repair for Excel to fix the saving error if it is due to corruption in the Excel file.

It is easy to work with Microsoft Excel but sometimes, the application may create issues thereby hampering the smooth functioning of the workbook. One such issue is “unable to Save Excel Workbook”.

Let’s take a look at the issue of Unable to Save Excel Workbook

Instance 1:

In an organization, users connected to one of the servers (Windows 2008 R2) using Citrix – a Terminal Server configured with Windows 2008 R2 –and accessed their data through a File Server, also configured with Windows 2008R2. Since the connectivity to Shared Drive was established through a Terminal server, any conflict amongst the server configuration may create conflict in shared file.

This issue was discussed at length at one of the Tech Forums , where the users were unable to access their workbooks stored on the shared drive. The File menu did not work. As a result, the users were forced to save the workbook by creating quick access shortcuts or locally on the desktop. In many cases, the saving option was ruled out completely.

Instance 2:

A similar problem was reported, wherein the users received an error when saving an Excel workbook after inserting a chart in an existing workbook (previously saved) or copying values from an existing workbook. A system is configured with Windows 7 and Microsoft Office 10 configuration. The issue arises when the user is unable to save the changes after editing in a saved spreadsheet. The following message displays on the screen:

Figure: Unable to Save Excel WorkBook Issue

Further, if the user clicks ‘Continue’, the following error message is received:

“Excel encountered errors during save. However, Excel was able to minimally save your file to <**filename.xlsx**>”.

Note: This issue impacts build Version 1707 (Build 8326.2086) and later, and also only occurs with files that are stored locally, such as on the desktop. This problem does not occur if you manually enter values or insert a chart in a newly created workbook.

Plausible reasons for the ‘Unable to save Excel workbook’ Issue

The issue was detected in Microsoft Office Professional Plus 2010 32-bit, Service Pack 14.0.6029.1000.
Excel version on the user system may or may not match with Excel version on File server.
The issue of ‘Unable to Save Excel Workbook’ impacts only the Build Version 1707 (Build 8326.2086) and later.
In case of Issue 2, the problem surfaces when the user adds files, tables or charts in the locally saved excel files, such as on the desktop.

Methods to fix the ‘Unable to Save Excel Workbook’ Issue

There may be an issue with the Build version or the Registry Values settings may not be appropriate, which does not allow the Excel workbooks to save.

But, before starting to resolve the issue, verify the following:

The location where the file is to be saved may not have enough space to save the Excel file: Check the available space and save again. You may also use the option of ‘Save As’ to save the file at a new location.
Excel file may be a shared one where edits are not allowed by a specific user: There are restrictions attached to documents and other files shared over the network. Check for these restrictions.
Antivirus may interrupt in during file saving: Antivirus in the system may not allow saving of the files. Request the system administrator to uninstall the antivirus and reinstall after saving.
The file is not saved within 218 characters: If the file is not saved due to the naming issue, then check the character length and try again.
Differences in Windows versions of the local system and those on network drive may cause excel not saved issues. Check that all the systems have the same configuration and are updated to the recently available versions.
Excel spreadsheet is corrupt: If none of the above factors have not caused hindrance in saving the file, then there may be a probability of corruption in the Excel spreadsheet .

Once verified, look for a healthy and restorable backup. If backup is missing, resolve the issue of “Unable to open Excel File” with manual settings on local system or through a reliable Excel repair software.

Method 1: Modify Registry Entries

If multiple users are unable to access their workbooks stored on the shared drive and facing unable to save Excel file problem (see Instance 1 above), then follow the below steps:

Go to ‘Registry Entry’. To do this, type ‘regedit’ in the Start Search box, and press ENTER

Figure: Edit Registry

You are prompted for the administrator password or for a confirmation, type the password, or click Continue
Locate the following registry subkey, and right-click it: HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\CSC

Figure: CSC Location

Point the cursor to New, and click Key

Figure: Create new key

Type ‘File Parameters’ in the available box

Figure: File parameters

Right-click Parameters, point the cursor to New, and click DWORD (32-bit) Value

Figure: File parameter (DWORD – 32 bit) value

Type ‘FormatDatabase’, and press ‘ENTER’. Right-click ‘FormatDatabase’, and click ‘Modify’

Figure: Modify format database

In the Value data box, type ‘1’, and click ‘OK’

Figure: Value data

Exit ‘Registry Editor’
Restart the system and verify if the files can be saved now

Method 2: Try Google Uploads

If the user is unable to save the changes after editing in a locally saved spreadsheet (see Instance 2 above), then follow these steps:

Upload the unsaved Excel file to Google Docs. Ensure that the file gets converted to Google Sheets format.
Check if all the formulae are active and working.
Make changes to the Google Sheet and verify that all the changes are working fine.
Use the Google Sheets export feature to download the file in Excel format.

Method 3: Resolve manually with Open and Repair

If the Excel file is found to have corruption, try out the Excel Open and Repair utility:

Open a blank Excel File. Go to File and Click Open.
Go to Computers and click Browse.
Access the Location and Folder and click the arrow icon beside Open followed by Open and Repair.

Figure: Illustrates Steps to use ‘Open and Repair’ method

The Open and Repair utility is not competitive enough and may not fix corruption in severely corrupted files. Hence, if you are unable to save Excel workbook after applying the manual methods, then you can search for a useful software-based repair utility.

Method 4: Excel File Repair Software

Specifically meant to resolve Excel file corruption. Stellar Repair for Excel helps you to repair every single object including charts, tables, their formatting, shared formulae and rules and more.

Install and Open the software and select the corrupt Excel File. You can also click the Find option if the file location is not known.
Click Scan and allow the software to scan and repair the corrupt Excel file.
Once repaired, the software displays the fixed file components to verify its content.
Click Save to save the file data in a blank new file as ‘Recovered_abc.xls’, where abc.xls is the name of the original file.

See the working of the software which has been declared as a tool that provides 100% integrity and precision.

The Excel repair software takes care to save the repaired data in a new file to minimize the chances of further corruption.

Conclusion

‘Unable to save Excel file’ is a generic problem that may appear due to various reasons. In this blog post, we presented some of the actual instances reported by users on community forums.

Windows updates, the Build versions, the Service Packs of the local systems and those on the network drive must be either similar or in sync with each other. Any deviation may cause issues in accessing or saving the Microsoft files, as reported in Instance 1 is caused where user is unable to save Microsoft Excel file on the Network Drive. In case, the user is unable to save the file on network drive then the problem lies with the Registry value.

Another case is when the users receive an error while saving an Excel workbook after they insert a chart in an existing workbook or copying values from an existing workbook. This issue is known to affect build Version 1707 (Build 8326.2086) and later, and only occurs with locally stored files.

When a user is unable to save a specific Excel file, then the problem can be resolved using the manual methods or the software based utility. The mode of repair depends upon the level of corruption in Excel file.

Hence, it is suggested to analyze the nature of the problem and decide an appropriate resolution method.

Ways to Fix Personal Macro Workbook not Opening Issue

Many users have reported encountering issues while accessing personal macro workbook, such as personal macro workbook not opening, personal macro workbook not loading automatically, Excel personal macro workbook keeps getting disabled, etc.

Such issues may arise due to a problem with the directory where the personal workbook is stored. However, there are various other reasons that may lead to such issues. Below, we’ll discuss the reasons behind the personal macro workbook not opening issue and the solutions to troubleshoot and fix the issue. But before proceeding, let’s understand why personal macro workbook is used.

Why Personal Macro Workbook is used?

You can access macros in a specific Excel workbook. However, when you need to use the same macro in other Excel worksheets, then you can create a personal macro workbook. A personal macro workbook (Personal.xlsb) is a hidden workbook that is used to store all macros. It makes your macros available every time you open Excel.

Causes of Personal Macro Workbook not Opening Issue

You may encounter personal macro workbook is not opening issue when attempting to record macros. Some possible causes behind such an issue are:

Personal macro workbook is stored at an untrusted location
Location of xlsb is changed
Personal macro workbook is hidden
Personal macro workbook becomes corrupted
Disabled items in add-ins
Workbook is Read-only

Methods to Fix the “Personal Macro Workbook not Opening” Issue

Follow the given methods to fix the personal macro workbook is not opening issue:

Method 1: Check the Path of Personal.xlsb

The personal macro workbook (Personal.xlsb) file is stored in XLStart folder. It opens automatically when you open your Excel application. However, sometimes it fails to load automatically. It usually occurs when you try to open the file from an incorrect path. You can check the path of Personal.xlsb by following these steps:

Open the workbook.
Click on the Developer tab.

Press Alt + F11 to open Visual Basic Editor.
Go to View > Immediate Window.

In Immediate Window, type the following code to know the location of the workbook:

?thisworkbook.path.

Then, hit Enter.

You will see the path of the personal macro workbook.
Copy the path and paste it into Quick Access field in File Explorer.

Method 2: Unhide Personal Macro Workbook

If personal macro workbook is hidden, you may unable to see and open the Personal.xlsb file. To unhide the personal Macro workbook, follow the below steps:

In Microsoft Excel, go to View and then click Unhide

The Unhide dialog box is displayed. Click PERSONAL and then OK.

Method 3: Enable the Macro Add-ins

You may unable to open the previously recorded macros in your personal macro workbook if the macros are disabled. To check and enable the items, follow these steps:

Go to File > Options.
In Excel Options, click on the Add-ins
Select Disabled Items from the Manage section and click on Go.

The Disabled Items dialog box appears. Click on the disabled item and then click Enable.

Method 4: Change the Trusted Location

You may encounter the “personal macro workbook not opening” issue if the Personal.xlsb file is stored at an untrusted location. You can check and modify the path of XLSTART folder using the Trust Center window. Here are the steps:

Open MS Excel. Go to File > Options.
Click Trust Center > Trust Center Settings.
In the Trust Center Settings dialog box, click on Trusted Locations.

Verify the path of the XLSTART If it is untrusted or there is any issue, then click Modify and then click OK.

Method 5: Repair your Excel File

You may fail to open personal macro workbook if it is corrupted. To repair the corrupt workbook, you can use the built-in Open and Repair utility in MS Excel. To use this tool, follow these steps:

Open your Excel application.
Click File > Open.

Browse to the location where the corrupted file is stored.
In the Open dialog box, select the corrupted workbook.
From the Open dropdown list, click Open and Repair.

The dialog box appears with the Repair and Extract buttons. Click Repair to retrieve all possible data or the Extract option to recover the data without formulas and values.

If the Open and Repair utility fails to repair the corrupted Excel workbook, then you can use a professional Excel repair tool, such as Stellar Repair for Excel. It can easily repair severely corrupted Excel (XLSX and XLS) files and recover all the components. You can download the free trial version of the tool to preview the recoverable data.

Closure

This article discussed the ways to fix the personal macro workbook not opening issue. In case you are unable to open the personal macro workbook because of corruption in the workbook, you can use the Open and Repair utility in MS Excel. If it fails, then you can use Stellar Repair for Excel to fix corruption in the Excel file and recover all its data with complete integrity.

How to repair ‘recovered’ Excel file that won’t open

Summary: You may unable to open the Excel file after file recovery. When you try to open the file you may prompt up with error messages. This blog will discuss those errors and their solutions. Besides this, it also mentions Stellar Repair for Excel to repair and recover the severely corrupted Excel file with no data loss.

Consider a scenario: A Windows 10 user accidentally deletes a folder containing multiple Excel (XLSX) files created in Excel 2013. The worst part was all the deleted files were important, and he did not have a backup, which would help him in restoring the data. Nonetheless, he was able to recover those data using a professional data recovery software. Next, he tried opening each of the recovered Excel files one by one. In doing so, his happiness turned into disappointment. And the reason was, some of the recovered Excel files failed to open prompting error messages, of course, due to corruption. In this scenario, all he needed was to repair ‘recovered’ Excel files that did not open. Know how to fix damaged Excel files that were recovered after deletion in this blog!

Before delving into the Excel file repair methods, acquaint yourself with the probable causes leading to damaged or corrupt Excel files. Although not essential, it shall be an added advantage in helping you to prevent Excel file corruption issues in the future.

The standard Excel file(s) Corruption Causes

Power Outage – A power outage due to which a system closes suddenly or unexpectedly is a common cause of damaged Excel files.
Forced System Shutdown – Shutting down the system forcibly without closing MS Excel files is another common cause of corrupt Excel files.
PC Virus or Bug – Computer viruses or bugs may affect one or more data file if owners do not protect their PCs with powerful updated antivirus. Same is the case with malware attacks. The chances are that your computer is infected with one of these and has affected a few Excel files.
Issues with Storage Devices – Damaged or corrupted Excel files can also be the outcome of hard drive issues in the data storage systems. Logical hard drive damage is one of the most significant issues.

The damaged Excel files may prompt up with error messages. These may be:

‘Excel unable to read file’
‘Filename is not valid’
‘This file is not in a recognizable format’
‘abc.xls file cannot be accessed. The file may be read-only’
‘Excel found unreadable content in (filename)’, ‘The file is corrupt and cannot be opened’
‘Microsoft Excel has encountered a problem and needs to close’

There exist multiple methods to repair Excel files which got damaged after recovery, and are as follows: XML method,

Open Excel files with HTML
Inbuilt ‘Open and Repair’ feature/tool in Excel
Repair damaged Excel file from TMP file by using Excel AutoRecover and AutoBackup features
Recover data by configuring ‘calculation option’ as manual
Moving/copying or transferring data to a different location
Stellar Repair for Excel software

Taking Stellar software versus other methods, the former is a software solution that repairs damaged (XLS and XLSX) file quickly in major three steps: Select->Repair->Save, whereas others fall into the category of manual processes and consume both time and resources. Among the manual processes ‘Open and Repair’ method is the least time and resource consuming, which you can try quickly by following the below steps:

Open and Repair method

Click MS Excel tab and then the Open tab
Select the damaged Excel file for repairing purpose
Click the arrow present beside the Open Next, click Open and Repair tab
Click either of the following:
- Repair tab (recovers maximum data)
- Extract Data tab (Recovers values and formulas if the repair process fails in recovering the complete data.)

Note – Use ‘Extract Data’ if ‘Repair’ is not successful.

If the Manual method is not competent enough to repair recovered Excel files that don’t open then opt for a software-based solution of deploying Stellar Repair for Excel software.

Software with 100% integrity and precision

Conclusion

As an automated software, Stellar Repair for Excel is easy-to-use. You do not need technical know-how and skill set, as required to execute the manual processes. On analyzing all these methods, it is suggested to use Stellar Repair for Excel having a user-friendly GUI to repair Excel files that became damaged after recovery, or if the recovered Excel file(s) that you once deleted accidentally has become corrupt now. Above all, it is an excellent software with multiple features and advantages. Use it to address all your MS Excel issues or if any recovered Excel file is corrupt.

Review Topics

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