Common Corruptions in styles.xml and How to Fix Them

A cell references a style index that does not exist in cellXfs.

Repaired Records: Cell information from /xl/worksheets/sheet1.xml part

<!-- styles.xml: cellXfs has count="2", so valid indexes are 0 and 1 -->
<cellXfs count="2">
  <xf .../>   <!-- index 0 -->
  <xf .../>   <!-- index 1 -->
</cellXfs>

<!-- sheet1.xml: cell uses s="9" which does not exist -->
<c r="B2" s="9"><v>12500</v></c>   <!-- ← CORRUPT: index 9 does not exist -->

Fix: Change s="9" to a valid index. s="0" always works as it is the default style.

<!-- Fixed -->
<c r="B2" s="0"><v>12500</v></c>

Each section (<fonts>, <fills>, <borders>, <cellXfs>) has a count attribute. If the count doesn't match the actual number of child elements, Excel will error or silently repair.

<!-- CORRUPT: count says 5 but only 2 font entries exist -->
<fonts count="5">          <!-- ← wrong count -->
  <font>...</font>         <!-- index 0 -->
  <font>...</font>         <!-- index 1 -->
                           <!-- Excel expects 3 more entries that aren't here -->
</fonts>

Fix: Count the actual child elements and update the count attribute to match.

<!-- Fixed -->
<fonts count="2">
  <font>...</font>
  <font>...</font>
</fonts>

The spec requires index 0 to be a none fill and index 1 to be gray125. Many programmatic XLSX writers skip these and start with their own fills at index 0. This shifts all fill indexes by 2, so every cell with a background color displays the wrong one — or errors entirely.

<!-- CORRUPT: missing the two required reserved fills -->
<fills count="1">
  <fill>
    <patternFill patternType="solid">
      <fgColor rgb="FFFFFF00"/>                  <!-- yellow — but it's at index 0, not 2 -->
    </patternFill>
  </fill>
</fills>

<!-- Fixed: reserved entries first, then custom fills -->
<fills count="3">
  <fill><patternFill patternType="none"/></fill>      <!-- index 0: REQUIRED -->
  <fill><patternFill patternType="gray125"/></fill>   <!-- index 1: REQUIRED -->
  <fill>
    <patternFill patternType="solid">
      <fgColor rgb="FFFFFF00"/>
    </patternFill>
  </fill>                                             <!-- index 2: yellow -->
</fills>

Less of a hard corruption and more of a progressive problem. Workbooks used heavily over months or years — especially ones where many users paste data from other sources — accumulate thousands of duplicate style entries. A styles.xml that should be 20KB becomes 2MB.

What you will see:

• Extremely slow saves
• "Too many different cell formats" error
• Occasional "Excel found unreadable content" on open

xl/
  styles.xml    2,847 KB    ← should be under 100KB for most workbooks

Fix: Copy all data to a new workbook using Paste Special > Values. This strips all direct formatting and resets styles.xml to a minimal clean state. You will need to reapply any intentional formatting afterward.