How to Repair Corrupt Excel File Custom UI Error

Part 1: What is the Error cause Excel File get Corruption

Among common Excel errors, following Custom UI error may appear:

"Multiple custom UI parts were found in the file. Only one part is expected"

To understand the various possible reasons for this error (which may not let Excel to proceed and the Excel file corruption may occur), one should know what custom UI is and what its contents are. As a custom, UI contains user defined option which can be part of Add-ins. These UI facilitate customized menu or what are known as Ribbons.

MS Office permits such add-ins for the user to include certain buttons (or controls). For Excel, these custom UI are coded in XML in which controls are embedded. MS Office have XML relationship file (.rels) for XML compatibility which contains type and target.

Now the reason for the above-stated custom UI error generally is due to the fact that certain parameter in XML may be using a single value in the relationship file to handle but either invalid or multiple values are erroneously coded in XML. At Excel, execution time will give this particular error because excel will hang up finding no valid option or control value to proceed.

For example, in a ‘Toggle-Button’ either of two values is permitted but if coding contains multiple values or the control does not check for the valid option, custom UI error of this type will appear.

Similarly ‘Check-Box’ during execution either have to be check-marked or left blank. This should be coded in XML and Excel will expect part or value. Error in XML, therefore, will display same custom UI error.

In MS word, for example, Bright or Italic or Underline controls (although are not custom UI) have a single value in the code to handle but in a likewise situation in UI error will be displayed if many parts are given in the code.

Part 2: Repair MS Excel File with Excel Repair Tool

Although a non-professional excel user will neither be dealing with add-ins or custom UI but if such an error comes up and consequently excel file is either damaged or gets corrupted accidently, what is easy and best workable solution for such a user? Even for the professional, an easy way out is to use third party Excel file repair software. Why invent the wheel? Many file repairing tools are available which are not free, though. Also hiring a credible professional to repair corrupted Excel file is daunting many times.

Stellar Phoenix Excel Repair software that is undoubtedly the best excel file repair software has two versions. Demo version is free. This is to facilitate user understand and get the basic confidence in its use. This Excel file repair software is available for single as well as multiple systems. This excel Repair tool supports all versions of windows and supports Excel 2011 for Mac. This permits repair corrupted Excel file (.XLS and .XLSX), and restore all the data from corrupt to a new Excel file.

Microsoft Excel Repair Tool
  • Recovers all kind of data stored in damaged excel file such as tables, charts, formulas, comments, images, etc.
  • Restore all of your corrupted excel files to their original standing.
  • Preview the repaired excel file in real-time,see how much of the file has been recovered as it is being repaired.
  • All kind of MS office corruption errors (for XLS and XLSX files only) can be handled with this tool.
  • This excel file repair tool can be used on both windows and Mac platforms in order to repair corrupt excel file.
  • All kind of MS office corruption errors (for XLS and XLSX files only) can be handled with this tool.
  • This excel file repair tool can repair damaged files of all versions from 2000 to 2016 that includes 2000, 2003, 2007, 2010, 2013, etc.

For Windows following steps, the sequence may be followed to easily repair or recover Excel files, corrupted or damaged. For Mac option is there and can be used the same way.

Step 1 To select corrupt Excel files location (drive, folder, file.

repair corrupted excel file step 1

Step 2 All corrupt or damaged Excel files display in the searched result section, select one to scan.

repair corrupted excel file step 2

Step 3 After scanning the corrupt Excel file,you can preview the repaired Excel files.

repair corrupted excel file step 3

Step 4 Select location to place repaired files

repair corrupted excel file step 4

Tips:

In addition to Excel Repair Tool or Excel file repair software, a few tips may help quick fixes to recover or repair corrupted Excel file.

Case 1. When Excel cannot open the file, try one of the following.

  1. Copy and open corrupt file on hard-drive.
  2. Find .xlb file. Also keep a backup as well. Delete .xlb. Restart Excel.
  3. Try opening the file in MS word or Notepad. However, that will let you recover data but not formatting.
  4. With MS Excel 97/2000 viewer you can view the data and print. Open file using this free program to recover data. This program will recover formatting as well as cell values.
  5. Use Excel XP. This has better options for recovery.

Case 2. When Excel file is open try any one of followings.

  1. Try on a different computer
  2. Switch off Auto-save
  3. Turn off the file sharing
  4. Do not run Excel from a floppy
  5. Save the file as a web page and reopen it as Excel file
Hot Articles
See MoreSee Less
Home / Office Document Repair / How to Repair Corrupt Excel File Custom UI Error

All TOPICS

Top

You are visiting computer data recovery page, if you want to recover your mobile data, please visit Dr.Fone - Phone data recovery