Convert an Excel 4.0 crosstab table to a PivotTable report

1. Open the workbook that contains the crosstab table in the current version of Microsoft Excel
2. Click a cell in the crosstab table.
3. On the Data menu, click PivotTable and PivotChart Report.
4. Click Finish, and click OK in response to the prompts.
5. Save the workbook in the current version of Excel.

   You cannot use Undo to change the PivotTable report back to a crosstab table. If you want to keep a copy of the crosstab table, keep an extra copy of the Excel 4.0 file.

Note  The new PivotTable report does not use the outline from the crosstab table. To remove the outline, point to Group and Outline on the Data menu, and then click Clear Outline.