Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

Performance degradation opening Excel workbooks


View products that this article applies to.

Symptoms

When are opening a workbook that contains at least one shape with text added to it you receive an error�"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�.

After you click �Yes�, Excel could appear to hang before it opens the workbook and eventually deletes the text that causes the performance problem.

You may receive an additional alert similar to:

Excel was able to open the file by repairing or removing the unreadable content.
Repaired Records: Drawing from /xl/drawings/drawing1.xml part (Drawing shape)"

↑ Back to the top


Cause

The issue can occur if the text in the Shapes contains XML tokens ('<' and '>', 'lt;' and '&gt;'). When opening a workbook in Excel 2010, Excel tries to read the content of that workbook and while reading the text (that contains XML tokens) from the Shapes, Excel encounters a performance problem and eventually deletes that text before completing the open process.

↑ Back to the top


Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.


↑ Back to the top


Workaround

Do not store XML data inside a graphical shape. XML data can be stored in Custom XML sections in a workbook.

↑ Back to the top


Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.

↑ Back to the top


Keywords: KB2384361

↑ Back to the top

Article Info
Article ID : 2384361
Revision : 5
Created on : 5/15/2012
Published on : 5/15/2012
Exists online : False
Views : 413