Microsoft KB Archive/928976

From BetaArchive Wiki
Knowledge Base


Error message when you open a workbook that contains cells that you filled with a reference to a relative name in Excel 2007: "Excel cannot complete this task with available resources"

Article ID: 928976

Article Last Modified on 10/15/2007



APPLIES TO

  • Microsoft Office Excel 2007



SYMPTOMS

Consider the following scenario. In Microsoft Office Excel 2007, you create a workbook that contains a relative name. Then, in another new workbook, you press CTRL+ENTER to fill a range of cells with a reference to the relative name. You save the second workbook as an "Excel 97-2003 Workbook (*.xls)" file and then close both workbooks. In this scenario, you receive the following error message when you reopen the second workbook:

Excel cannot complete this task with available resources. Choose less data or close other applications.

When you click OK to close the error message, you receive the following message:

Excel found unreadable content in 'filename.xls'. Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes.

To determine the unique number that is associated with the message that you receive, press CTRL+SHIFT+I. The following number appears in the lower-right corner of this message:

101648

When you click Yes to recover the contents of the workbook, you receive the following error message again:

Excel cannot complete this task with available resources. Choose less data or close other applications.

Then, when you click OK to close the error message, you receive the following message:

Excel was unable to open the file by repairing or removing the unreadable content.

Excel recovered your formulas and cell values, but some data may have been lost.

WORKAROUND

To work around this issue, use one of the following methods:

  • Open the workbook that contains the relative name first. Then, open the workbook that contains the reference to the relative name.
  • Save both workbooks as Excel workbook files. To do this, click the Microsoft Office Button, click Save as, and then click Excel Workbook (*.xlsx) in the Save as type box.



Additional query words: excel2007 excel2k7 excel12 xl2007 xl2k7 xl12

Keywords: kberrmsg kbtshoot kbprb kbxlslink kbexpertisebeginner kbofficealertid KB928976