Note that you normally receive this error message when you create a pivot table if the path you type in the Range box in the PivotTable Wizard is incorrect, or if the file is not available. However, in this case, you can use the Browse button in the PivotTable Wizard to locate the file and continue creating the pivot table.
- Open the file that contains the data that you are using in the crosstab table before you choose PivotTable from the Data menu. -or-
- Create the crosstab table from a database contained in a Microsoft Excel worksheet file.
Article ID: 117314 - Last Review: Aug 15, 2003 - Revision: 1