XL2000: "Problems came up in the following areas during load..." Error Exporting Spreadsheet or PivotTable to Excel

ID: Q210824

The information in this article applies to:

Microsoft Excel 2000
Microsoft Office Chart Component 9.0, design time
Microsoft Office Chart Component 9.0, run time
Microsoft Office PivotTable Component 9.0, design time
Microsoft Office PivotTable Component 9.0, run time 9.0

SYMPTOMS

When you click Export to Excel on the Microsoft Office Spreadsheet toolbar, you receive the following error message:

Problems came up in the following areas during load:

Number Format
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 the following error message:

Problems came up in the following areas during load:

PivotTable
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 INFORMATION

For more information about using 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.

Additional query words: XL2000 pivotlist webcalc

Keywords :
Version : WINDOWS:2000,9.0
Platform : WINDOWS
Issue type : kbprb