XL2002: "Problems Came Up in the Following Areas During Load..." Error Exporting Spreadsheet or PivotTable to Excel (291060)
The information in this article applies to:
- Microsoft Excel 2002
- Microsoft Office XP Web Components
This article was previously published under Q291060 For a Microsoft Excel 2000 version of this article, see 210824.
SYMPTOMS
When you click Export to Excel on the Microsoft Office Spreadsheet toolbar, you receive an error message similar to the following:
Problems came up in the following areas during load:
A log file has been created listing the load errors. This file has been saved to the following location: c:\windows\temp\HtmlErr.log.
When you click OK, Microsoft Excel loads the spreadsheet, but without some of the formatting that was applied in the spreadsheet control.
-or-
When you click Export to Excel on the Microsoft Office PivotTable toolbar you receive an error message similar to the following:
Problems came up in the following areas during load:
A log file has been created listing the load errors. This file has been saved to the following location: c:\windows\temp\HtmlErr.log.
When you click OK, Microsoft Excel loads the PivotTable, but without some of the formatting that was applied in the PivotTable list control.
CAUSE
These problems occur when you use a number format in your Office Spreadsheet or PivotTable list that Microsoft Excel does not support.
WORKAROUND
To work around this problem, you must only use number formats that are compatible with Excel.
MORE INFORMATIONFor more information about custom number formats in Excel, click Microsoft Excel Help on the
Help menu, type custom number formats in the Office Assistant or
the Answer Wizard, and then click Search to view the topics
returned.
| Modification Type: | Major | Last Reviewed: | 10/29/2003 |
|---|
| Keywords: | kberrmsg kbprb KB291060 |
|---|
|