Fix Cannot Paste the Data Error in Microsoft Excel 2000 | Stellar

Fix Cannot Paste the Data Error in Microsoft Excel 2000 | Stellar

Nova Lv13

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.

Clicking Cell Font In Home

  • In the Format Cells dialog box, click Protection.

Selecting Protection from Font family with formatting

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

Click on Locked Cell under Protection Tab

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.

Navigate to Home and Click general drop down menu in Excel

  • 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.

Navigate to Home And click on Paste Special in Excel

  • 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.

Click on Paste and Selection of Operations from Paste Special Properties

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.

Under Excel Navigate to Home and click on Merge and Center

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.

Under Excel Navigate to Home and click on Merge and Center

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.

[Error Solved] Excel file is not in recognizable format

Summary: Microsoft’s Excel is one of the most widely used spreadsheet tools, however, it isn’t entirely free of errors. There are in fact quite a large number of problems that can crop up in this user-friendly application which can put all work to halt. One such error occurs when Excel does not recognize the file format of .xls or .xlsx file and the error message says “Excel file is not in recognizable format” error. Let us explore this annoying error in detail.

Free Download for Windows

Excel file is not in a recognizable format

Figure: Error message

From a small shop to the global industry giants, everyone relies on Microsoft Excel to complete their work. Quite a few businesses not only use Excel for their inventory tracking purposes but also to manage task lists and timesheets for their employees and project management charts. With high programming proficiency, one can create macros in excel which help in automating a lot of things. You can create quite a few variations, such as pie charts, bar charts, line graphs, area charts, and many more to showcase the data both in a tabular column as well as in a pictorial representation.

While Excel enjoys wild popularity, thanks to its powerful design and features, it doesn’t mean that Excel is all free of errors. There are actually repetition a few errors that one can encounter. One you might have come across is the error stating “Excel file is not in a recognizable format”.

What is this error all about?

The “Excel file in unrecognizable format error” occurs when the Excel file you are trying to load is corrupted. Microsoft has ensured that the workbook will be recoverable when the file is imported into excel but there are times when the automatic recovery does not happen. That’s where the challenge really lies. In such cases, getting to the root of the issue becomes necessary to be able to solve it.

Reasons behind the error

  1. One of the main reasons for the error is that the file must have got corrupted while being transferred from one machine to another.
  2. Another reason can be that the latest service pack might not be in use on your system.
  3. There could be MS Excel version change.
  4. Corruption of the file due to virus infection, extremely large databases, or multiple locks on the file at the same time can also trigger this error.

If you have ever faced this error, you do not need to panic. We have a couple of solutions listed for you when you face the Excel file in an unrecognizable format error.

How do you go about fixing this?

Solution 1: Use MOC.exe file to convert the workbook and then open it in Excel:

  1. Right-click on .XLS (you can use any .XLS files in your system).
  2. A new dialogue will appear. Here, click on “Choose another app” to select it.

Choose Another App

Figure: choose another app

  1. You will now be presented with a number of applications which the OS thinks the file format will be compatible with.
  2. You do not have to choose any of the prepopulated apps from the list.

Look for another app

Figure: Look for another app

  1. Navigate using the Look for another app on this PC  to the path “C:\Program Files\Microsoft Office\OfficeVersion”
  2. You will see a file name MOC.exe
  3. Choose that and complete your export.
  4. Try opening the workbook in Excel and the error should now be resolved.

Solution 2: Opening the file from within the Excel:

  1. Open a new Excel workbook.
  2. Press “Alt + F” or alternatively, go to the menu.
  3. Once you are in the menu, go to Options.
  4. You will be able to see a number of tabs on the left side of the options.
  5. Under the ‘Formulas’ tab, ensure that the calculation is in Manual mode – this setting is in the automatic mode, by default.

Manual option

Figure: Manual option

  1. Click OK and save the changes to the workbook.
  2. Now, browse for the file which was corrupted.
  3. Click on the file and then select the option “Open and Repair”. You will find it in the drop down Menu.

Open and Repair

Figure: Open and Repair

  1. Once the file has been imported, click on “Repair” to recover the data from the selected workbook.

Repair Option -Excel File

Figure: Repair option

Solution 3: Use automated Excel repair software

If none of the above mentioned manual methods works to eliminate the ‘Excel file in unrecognizable format’ error, it means your Excel file has been severely corrupted and needs professional assistance. In such a scenario, quickly download reliable and competent software Stellar Repair for Excel. Backed by powerful scanning and repair algorithms, this product guarantees up to 100% Excel file repair regardless of the amount of damage in it.

  1. Download, install and launch Stellar Repair for Excel.
  2. Allow the software to scan the corrupted Excel file.
  3. All recoverable data will be listed in a tree-view list. You can select and preview any item from here.
  4. Select and recover individual or entire data from the file and save as a new Excel.

This method is currently the easiest and most convenient to resolve miscellaneous Excel errors.

Wrapping it up

Excel is one of the most powerful tools which can easily reduce your workload by more than 75% if used in a proper way. However, if you face complex errors like “Excel file is not in recognizable format”, you can use the methods mentioned above to get rid of it and resume your working in MS Excel. Remember, if the manual solutions don’t work, you can always rely on a proficient software like Stellar Repair for Excel to complete the job with finesse.

Repair Files using Stellar Toolkit for File Repair

Stellar Toolkit for File Repair Technician

The main interface of Stellar Toolkit for File Repair comprises four modules to repair MS Office and PDF files. These modules are:

  • Repair Document
  • Repair Spreadsheet
  • Repair PowerPoint
  • Repair PDF

Click on the desired tab to repair that file format.

Homepage of Stellar Toolkit for File Repair

                                    Figure 1 - Illustrates Homepage of the Stellar Toolkit for File Repair

Steps to Repair MS Word – .doc/.docx file

  • Click Select File to select a single corrupt Word (.doc/.docx) file that you want to repair. Alternately, click Select Folder for selecting all Word files in a single folder.

Note: Click Find file(s) to search for the Word file, if the location is not known.

Select word file

                                     Figure 2 - Illustrates Selection of single doc/.docx file or multiple files

  • Once the file is selected, click the Scan button to scan and repair the file.
  • A preview of the repaired Word file is displayed on the screen. Verify the file contents from the right pane of the preview window.

Preview of word repair

                                         Figure 3 - Preview of Repaired Word Document

Note: If you’re unable to repair a corrupt .doc file, select ‘Advance Repair’ option from the File menu for repairing the .doc files.  

  • Click the Save icon on the File menu to save the repaired file.

Select menu

                                                                     Figure 4 - File Menu

  • In Save Document dialog box that appears, do the following:

  • Select default location or a new folder to save the repaired file.

  • Save the file in any of these formats: ‘Full Document’, ‘Filtered Text’ or ‘Raw Text’.

  • Click OK.

saving word document

                                                        Figure 5 - Word Document Saving Options

The repaired file will be saved at your preferred location.

Steps to Repair Excel – .xls/.xlsx files

  • In Select File window, click Browse to select the corrupt Excel file from the desired location. If you do not know the file location, click Search to find and select the corrupted spreadsheet.
  • Once the Excel file is selected, start repairing the file by clicking the Repair button.

Select xls/xlsx file

                              Figure 6 - Illustrates selection of one xls/xlsx file or multiple files in a folder

  • After completion of the repair process, the software displays the repaired Excel file and its recoverable data in a preview window.

preview of Excel file

                                                        Figure 7 - Preview of Excel File

  • Click on Save File icon on Home menu to save the repaired file.
  • In Save File dialog box, choose Default location or Select New Folder for saving the file.

Select destination to save repaired excel file

                                               Figure 8 - Select Destination to Save Repaired Excel File

  • Click OK to proceed with the saving process.

The repaired file gets saved at the preferred location.

Note: To recover the Engineering formulae, include ‘Analysis ToolPak’ Add-in.

 Steps to Repair PowerPoint – ppt/pptx/pptm file

  • Click Browse to select the corrupt PowerPoint file. Alternately, click on Search to search for the file, if the location is not known.

Select powerpoint presentation

                                    Figure 9 - Illustrates Selection of Single PowerPoint Presentation

  • Once the corrupt PowerPoint file is selected, click Scan for scanning and repairing the file.
  • A preview of scanned file gets displayed. Verify the file contents from the preview window.
  • Click Save on Home menu to save the repaired PPT file.
  • From the Save File dialog box, click Default location or Other location under Save As for saving the file.

www.sentrypc.com

Save ppt

                                                    Figure 10 - Select Location to Save PPT File

  • Click on the OK button and the repaired file is saved at preferred location.

Steps to Repair PDF file

  • From the Stellar Repair for PDF main interface window, click Add File to select a single or multiple PDF files you want to repair.

Adding corrupt pdf files

                                            Figure 11 - Illustrates adding of corrupt PDF Files

  • A screen with recently added PDF file is displayed. Select the file and click Repair to start repairing it.

Repair selected file

                                                Figure 12 - Repair the Selected PDF File

  • A screen showing the progress of the repair process appears.
  • When the ‘Repair Complete’ window pops-up, click OK.
  • Preview the repaired PDF file.
  • Click the Save Repaired Files button to save the repaired file.

BLUETTI NEW LAUNCH AC180T

save repaired file

                                                  Figure 13 - Save Repaired File

  • In Browse for Folder dialog box, select a folder for saving the file.
  • From the Saving Complete dialog box, click the hyperlink to the folder containing the repaired PDF file.

saving complete Window

                                                      Figure 14 - Saving Complete Window

  • Click OK.

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.

Free Download for Windows

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

  1. Click MS Excel tab and then the Open tab
  2. Select the damaged Excel file for repairing purpose
  3. Click the arrow present beside the Open Next, click Open and Repair tab
  4. 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

Free Download for Windows

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.

How Can I Recover Corrupted Excel File 2016?

Error Messages Indicating Corruption in Excel File

  • But sometimes, you encounter the “Excel cannot open this file” error message due to corruption in the file.

Excel-cannot-open-this-file

Why does Excel File turn Corrupt?

Following are some common reasons that can turn an Excel file corrupt:

  • Large size of the Excel file
  • The file is virus infected
  • Hard drive on which Excel file is stored has developed bad sectors
  • Abrupt system shutdown while working on a worksheet

Workarounds to Recover Data from Corrupt Excel

The workarounds to recover corrupted Excel file 2016 data will vary depending on whether you can open the file or not.

How to Recover Corrupted Excel File 2016 Data When You Can Open the File?

If the corrupt Excel file is open, try any of the following workarounds to retrieve the data:

Workaround 1 – Use the Recover Unsaved Workbooks Option

If your Excel file gets corrupt while you are working on it and you haven’t saved the changes, you can try retrieving the file’s data by following these steps:

  • Open your Excel 2016 application and click on the Open Other Workbooks option.

open-other-workbooks

  • Click the Recover Unsaved Workbooks button at the bottom of the ‘Recent Workbooks’ section.

recover-unsaved-workbook

  • A window with list of unsaved Excel files will open. Click the corrupt file you want to open.

This will reopen your last saved version of the Excel workbook. If this method doesn’t work, proceed with the next workaround.

Workaround 2 – Revert to Last Saved Version of your Excel File

If your Excel file gets corrupt in the middle of making any changes, you can recover the file’s data if the changes haven’t been saved. For this, you need to revert to the last saved version of your Excel file. Doing so will discard any changes that may have caused the file to turn corrupt. Here’s how to do it:

  • In your Excel 2016 file, click File from the main menu.
  • Click Open. From the list of workbooks under Recent workbooks, double-click the corrupt workbook that is already open in Excel.
  • Click Yes when prompted to reopen the workbook.

Excel will revert the corrupt file to its last saved version. If it fails, skip to the next workaround.

Saving an Excel file in SYLK format might help you filter out corrupted elements from the file. Here are the steps to do so:

  • From your Excel File menu, choose Save As.
  • In ‘Save As’ window that pops-up, from the Save as type dropdown list, choose the SYLK (Symbolic Link) option, and then click Save.

symbolic link format

Note: Only the active sheet will be saved in workbook on choosing the SYLK format.

  • Click OK when prompted that “The selected file type does not support workbooks that contain multiple sheets”. This will only save the active sheet.

Workbooks contain multiple sheets warning msg

  • Click Yes when the warning message appears - “Some features in your workbook might be lost if you save it as SYLK (Symbolic Link)”.

  • Click File > Open.
  • Browse the corrupt workbook saved with SYLK format (.slk) and open it.
  • After opening the file, select File > Save As.
  • In ‘Save as type’ dialog box, select Excel workbook.
  • Rename the workbook and hit the Save button.

After performing these steps, a copy of your original workbook will be saved at the specified location.

How to Recover Corrupted Excel File 2016 Data When You Cannot Open the File?

If you can’t access the Excel file, apply one of these workarounds to salvage the file’s data.

Workaround 1 – Open and Repair the Excel File

Excel automatically initiates ‘File Recovery’ mode on opening a corrupt file. After starting the auto-recovery mode, it attempts to reopen and repair the corrupt Excel file at the same time. If the auto-recovery mode does not start automatically, you can try to fix corrupted Excel file 2016 manually by using ‘Open and Repair’. Follow these steps:

  • Open a blank file, click the File tab and select Open.
  • Browse the location where the corrupt 2016 Excel file is stored.
  • When an ‘Open’ dialog box appears, select the file you want to repair.
  • Once the file is selected, click the arrow next to the Open button, and then click the Open and Repair button.
  • Do any of these actions:
  • Click Repair to fix corrupted file and recover data from it.
  • Click Extract Data if you cannot repair the file or only need to extract values and formulas.

repair excel file

If performing these actions doesn’t help you retrieve the data, proceed with the next workaround.

Workaround 2 – Disable the Protected View Settings

Follow these steps to disable the protected view settings in an Excel file:

  • Open a blank 2016 workbook.

blank excel file

  • Click the File tab and then select Options.

Excel file options

  • When an Excel Options window opens, click Trust Center > Trust Center Settings.

open excel trust center settings

  • In the window that pops-up, choose Protected View from the left side navigation. Under ‘Protected View’, uncheck all the checkboxes, and then hit OK.

www.sentrypc.com

disable-protected-view-settings

Now, try opening your corrupt Excel 2016 file. If it won’t open, try the next workaround.

### **Workaround 3 – Link to the Corrupt Excel File using External References**

If you only need to extract Excel file data without formulas or calculated values, use external references to link to your corrupt Excel 2016 file. Here’s how you can do it:

  • From your Excel file, click File > Open.
  • From the window that opens, click Computer and then click Browse and copy the name of your corrupt Excel 2016 file. Click the Cancel button.

browse corrupted excel file

  • Go back to your Excel file, click File > New > Blank workbook.

new excel workbook

  • In the new Excel workbook, type “=CorruptExcelFile Name!A1” in cell A1 to reference cell A1 of the corrupted file. Replace the ‘CorruptExcelFile Name’ with the name of the corrupt file that you have copied above. Hit ENTER.
  • If ‘Update Values’ dialog box appears, select the corrupt 2016 Excel file, and then click OK.
  • If ‘Select Sheet’ dialog box pops-up, select a corrupt sheet, and press the OK button.
  • Select and drag cell A1 till the columns required to store the data of your corrupted Excel file.
  • Next, copy row A and drag it down to the rows needed to save the file’s data.
  • Select and copy the file’s data.
  • From the Edit menu, choose the Paste Special option and then select Values. Click OK to paste values and remove the reference links to the corrupt file.

Check the new Excel file for recoverable data. If this didn’t work, consider using an Excel file repair tool to retrieve data.

Alternative Solution to Recover Excel File Data

Applying the above workarounds may take considerable time to recover corrupted Excel file 2016. Also, they may fail to extract data from a severely corrupted file. Using Stellar Repair for Excel software can help you overcome these limitations. The software helps repair severely corrupted XLS/XLSX file and retrieve all the file data in a few simple steps.

free download

Key benefits of using Stellar Repair for Excel are as follows:

  • Recovers tables, pivot tables, images, charts, chartsheets, hidden sheets, etc.
  • Maintains original spreadsheet properties and cell formatting
  • Batch repair multiple Excel XLS/XLSX files in a single go
  • Supports MS Excel 2019, 2016, 2013, and previous versions

Check out this video to know how the Excel file repair tool from Stellar® works:

Conclusion

Errors such as ‘the file is corrupt and cannot be opened’, ‘Excel cannot open this file’, etc. indicate corruption in an Excel file. Large-sized workbook, virus infection, bad sectors on hard disk drive, etc. are some reasons that may result in Excel file corruption. The workarounds discussed in this article can help you recover corrupted Excel file 2016 data. However, manual methods can be time-consuming and might fail to extract data from severely corrupted workbook. A better alternative is to use Stellar Repair for Excel software that is purpose-built to repair and recover data from damaged or corrupted Excel file.

Simple ways to Open Corrupt Excel file Without any Backup

Summary: The blog describes simple ways to open corrupt Excel file without any backup. It explains some manual workarounds that you can try to open the file. Also, it mentions about an Excel file repair tool that can quickly fix the corrupt file and recover data from it.

Free Download for Windows

Do you have an Excel file that does not open because of corruption issue? And every time you try to open it, an error message ‘the file is corrupt and cannot be opened’ pops-up?

Excel file is corrupt and cannot be opened message

Excel File Corruption Message

Also, you don’t have a healthy backup of the Excel file to restore the data? If so, you can try repairing the corrupt file by using a few simple yet effective manual workarounds mentioned below.

How to Open a Corrupt Excel File without Backup?

Following are some manual methods that can help you open a corrupt Excel file:

Method 1: Repair Corrupt Excel File

When attempting to open a corrupt file, Excel automatically starts ‘File Recovery’ mode to repair the file. But, if the recovery mode doesn’t start, try Microsoft Excel’s built-in ‘Open and Repair’ feature to manually repair the file.

To use this feature, perform the following steps:

Step 1: Open a Blank workbook in Excel, and then click File > Open.

Step 2: In the Open window, browse and select the corrupt file.

Step 3: Click the arrow that is beside the Open tab, and select Open and Repair.

Open a blank workbook in Excel, navigate to File > Open, choose the corrupt file, and, in the Open window, click the arrow beside the Open tab, selecting Open and Repair for file recovery.

Open and Repair Option

Step 4: Implement one of the following:

  • Click the Repair button. (This is to recover as much data as possible.)
  • Click the Extract Data button. (This is to recover values and formulas from the Excel file if the repair process fails to recover the entire data.)

Initiate file recovery by selecting the Repair tab, and if necessary, retrieve values and formulas using the Extract Data tab in Excel.

Excel Built-in Repair Options

If using Open and Repair does not work , move to the next method.

Method 2: Disable the Protected View Feature

Some Excel users have reported that turning off the ‘protected view’ feature in Excel helped them open the corrupt file. You can also try to disable this feature and open the file. To do so, follow these steps:

Step 1: Open a blank Excel file, click on File > Options.

Step 2: In the Excel Options window, select Trust Center, and then click Trust Center Settings.

In the Trust Center tab, click on Trust Center Settings...

Excel Trust Center Settings

Step 3: Click OK.

Now check if you can open the corrupt file. If not, try implementing the next method.

Method 3: Look For Automatically Recovered Excel File

If you have Excel’s AutoRecover feature enabled, you’ll have access to a copy of the Excel file corrupted or lost due to application crash, power outage, or accidental deletion.

The ‘AutoRecover’ feature saves Excel worksheets at a temporary location after a certain time interval. It saves the worksheets automatically and is turned on by default to reduce the chance of data loss.

Check if you can recover corrupted Excel file by following these steps:

Step 1: In Excel, open a Blank workbook.

Step 2: Go to File and click Options.

Open a new Excel workbook, then access additional settings by navigating to File and selecting Options.

Figure 5 – Excel Options

Step 3: In the Excel Options dialog box, click Save, and then copy the ‘AutoRecover file location’.

Copy the 'AutoRecover file location' for configuration or backup purposes.

Excel Options Window

Step 4: Open File Explorer window and paste the copied AutoRecover file location, and press Enter.

Step 5: A list of saved Excel files will be displayed. Choose the file you want to recover.

TIP: Use Excel’s AutoBackup feature to reduce chances of data loss, by saving a previous version of your spreadsheet automatically.

Use an Excel File Repair Software

If the above manual methods fail, repair the corrupt Excel file by using a third-party software, such as Stellar Repair for Excel**.** The software helps repair Excel (XLS and XLSX) files easily and effectively.

Free Download for windows

Read this: How to repair corrupt Excel file using Stellar Repair for Excel?

Some key features of Excel Repair software are as follows:

  • Fixes all errors in the MS Excel file.
  • Repairs multiple damaged Excel files in a go.
  • Recovers chart, chart sheet, table, cell comment, image, formula, and sort & filter.
  • Preserves properties and cell formatting of Excel worksheets.
  • Previews recoverable Excel file data before saving.
  • Recovers all data components from the corrupt files and saves them in a new blank Excel file.
  • Compatible with Excel 2019, 2016, 2013, 2010, 2007, and lower versions.

Conclusion

You can try the workarounds discussed in the blog to open a corrupt Excel file without a backup. Disabling the protected view feature can help you open the file. If the issue persists then try repairing the corrupted Excel file using the Open and Repair utility. Although, it may not be able to fix a severely corrupted workbook. In such a case you can use Stellar Repair for Excel . It is an advanced tool that can help you repair a corrupted Excel file with 100% integrity.

How to Repair Excel Document on a Flash Drive

Summary: Microsoft Excel files are stored on flash drives if they need to be transferred between systems or if they need to be backed up. But sometimes unforeseen issues can corrupt the Excel sheets stored on flash drives. When that happens, it can be an arduous task to repair Excel documents on a flash drive. Through this post let us try to understand the reasons why Excel sheets stored on flash drives can get corrupted and how users can resolve them easily.

Free Download for Windows

In this digital age, we all work with computers, files, and documents. Flash drives or USBs are common ways of storing data in an external place. Be it for a meeting or for a party playlist, these devices come handy when one wants to transfer data or access the files stored elsewhere.

You may need to access your data from another location. That’s when a USB flash drive might come in handy. And, that’s exactly why Excel sheets too end up on flash drives; either that or for backup purposes. However, there are many instances where an Excel file stored in a USB gets corrupted when one tries to access the file. The error message you get while trying to open the Excel file would be a great clue for figuring out the exact reason behind corruption.

This blog will provide insights into what are the reasons for the corruption of a USB and how the users can repair Excel on flash drive that has been corrupted.

## **Reasons for USB inaccessibility**

Sometimes flash drives or USBs can become unresponsive due to numerous reasons. There are two types of corruption – logical and physical. Physical corruptions occur due to broken stems and connectors, broken circuits, NAND gate, not recognised, RAW, need to format, not accessible, and dead drives (no power supply).

One of the main reasons behind such an error could be that the USB drive has been infected by some virus. This can affect any file – not only the ones which are there in the USB drive but also the ones which are there in the PC/Laptop where you connect the USB drive. It is recommended that you scan the USB drive with reliable antivirus software to detect viruses.

There can be various other reasons that may make your USB corrupt or unresponsive. But there are very slim chances that you will be able to recover a flash drive that has physical damage. However, you can try to run the check disk on the USB drive to fix the drive. We will be discussing this as you read on.

Recovery Methods for Corrupted Flash Drives

There are 3 tried and tested recovery methods. Try them and see which one works out for you.

  1. Restoring Excel Files from Windows backup

To bring back your old Excel files, fixing up the corrupt file is your best option. Importantly note that this method would work only if your system’s Windows backup option has been enabled.

Step-by-step process for restoring your older Excel files:

  • Connect your USB drive
  • Go to “My Computer”->USB Drive->Check if the file exists
  • Right click on the excel file and click on the restore previous versions

Restore Previous Versions

  • You will now see a list of older versions which were created
  • Select one the backups and click on “restore”
  1. Using Command Line to Recover Excel Files

In case you are looking to repair Excel on flash drive, you can also resolve it by using the command line. Just follow the below steps to see if you can recover the excel files.

  • Connect your USB Flash drive
  • Open “Run” (press Windows+R) and then open “cmd”

Windows+R cmd

  • Type “attrib -h -r -s /s /d (USB Drive Letter):\*.*” where the (USB Drive Letter) is the drive letter you can find using “My Computer”
  • Once this has been completed, Windows will start repairing your files
  • After the process gets over, try accessing the excel file to see if the data has been recovered
  1. Running a “Check Disk” on flash drives

Follow the below steps while the USB flash drive has been plugged into your computer:

  • Open “Run” and then open “cmd”
  • Type in “chkdsk /X /f (USB Drive Letter)” where the “(USB Drive Letter)” is the letter of the corrupted USB Drive. You can get this letter easily from the “My Computer”.

chkdsk  command prompt

It will now check your disk to and correct any corrupted records.

What if none of these methods works?

In case none of the above methods works to repair Excel document on a flash drive, then you would need a professional Excel repair software such as Stellar Repair for Excel to restore your files. Such software not only help repair corrupted Excel files on flash drives but also help in recovering the data stored within them in their original format.

Stellar Repair for Excel resolves corruption problems in Excel files and recovers all formulas, charts, cell formatting, and more from them. It can repair multiple Excel files in one go. Equipped with a fully interactive GUI, working with this product is extremely easy.

Free Download for Windows

To sum it up

Although flash drives are quite popularly used, they are not the most reliable of storage devices. These drives can fail anytime without warning. Thus, always back up your data on other more robust devices instead of flash drives. We hope that with the above tried and tested methods you will easily be able to repair Excel document on flash drive if need be. For any queries that you have, feel free to leave a comment below!


  • Title: Fix Cannot Paste the Data Error in Microsoft Excel 2000 | Stellar
  • Author: Nova
  • Created at : 2024-07-17 17:13:46
  • Updated at : 2024-07-18 17:13:46
  • Link: https://phone-solutions.techidaily.com/fix-cannot-paste-the-data-error-in-microsoft-excel-2000-stellar-by-stellar-guide/
  • License: This work is licensed under CC BY-NC-SA 4.0.
On this page
Fix Cannot Paste the Data Error in Microsoft Excel 2000 | Stellar