CopyPastehas never been so tasty!

Unable to delete corrupt Defined Names in Excel workbook?

by Dsmith

  • 0
  • 0
  • 4
313 views

In Excel, defined names are used to explain the meaning or content of a cell, a formula, or a constant. A defined name cannot be simply restricted to referencing a cell or a range of cells. For instance, you can have a defined name of MaxRows with a value 50, and you can use this instead of using the number. If you use the Name at different locations and wish to change the value, you just need to modify the definition and the new value will get automatically updated. However, at times you might come across various issues with an Excel workbook containing 'Defined Names'. These irregularities surface when an workbook becomes corrupt, leaving the information either in an unformatted state or totally inaccessible. In such workbook corruption scenarios, it is suggested you go for an Excel repair software.

Consider a scenario, wherein, you have an important Excel 2003 workbook with various defined names. Now, you wish to delete the same, but when you press 'Delete button' on the Defined Names dialog box, you might not be able to remove them.

Causes
You are not able to successfully delete it in the following conditions:

If you have a workbook which contains corrupt Defined Names ("__123Graph_APIE MEM") included from imported Lotus 1-2-3 spreadsheet files. Oftenly it contain non-printable characters and are likely to create problems.

Or if you have a partially corrupt or completely corrupt workbook

Resolution
The following xls file repair tips must be considered in order to resolve the issue:

In order to eliminate these corrupt Defined Names, you must first rename them. Here is a list of the steps to be taken:
1. Select Tools>Options, and click the General tab
2. Change the current settings and click the check box next to 'R1C1 Reference Style.'
3. Press OK
4. You will get prompted the name of any Defined Name containing illegal characters
5. To delete the newly-renamed select Insert, name and define
6. Go to Tools, Options, General and set the RICI Refernce Style as per the earlier settings

In case of corrupt workbook, you must download and bank upon a third-party Excel repair software.

The most trusted application for this purpose is Stellar Excel Repair. The tool repairs corrupt xls files in all scenarios and supports MS Excel 2007, 2003, 2002 and 2000. You can use this Excel file repair application to recover all the components (text, images, charts, tables etc) of an xls file in an absolutely safe manner.

Comments

  • JohnDempsey
    For restoring deleted or corrupted excel data try to use http://www.recoverytoolbox.com/repair_excel.html
    It works under any Windows OS. The tool works with any excel file format data and is compatible with different software configuration of PC.
  • JohnDempsey
    For restoring deleted or corrupted excel data try to use [url=http://www.recoverytoolbox.com/repair_excel.html]repair excel files[/url]. It works under any Windows OS. The tool works with any excel file format data and is compatible with different software configuration of PC.
  • BillyJonsey
    For restoring deleted or corrupted excel data try to use <a href="http://www.recoverytoolbox.com/repair_excel.html">repair Excel files</a>. It works under any Windows OS. The tool works with any excel file format data and is compatible with different software configuration of PC.
  • BillyJones
    For restoring deleted or corrupted excel data try to use http://www.recoverytoolbox.com/repair_excel.html
    It works under any Windows OS. The tool works with any excel file format data and is compatible with different software configuration of PC.

Add A Comment: