Article ID: 214349 - View products that this article applies to.
This article was previously published under Q214349
If you click PivotTable and PivotChart Report on the Data menu and then click Next to proceed to step 2 of the PivotTable and PivotChart Wizard, the Range reference box may contain the word "Database."
If you click Next again, you may receive the following error message:
Reference is not valid.
This problem may occur if the following conditions are true:
To work around this problem, select the range for the list that you want to use in the PivotTable, and then click Next.
You can also delete the invisible name "Database". To do so, follow these steps:
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
You can use the data form in Microsoft Excel to see, change, add, delete, and find records in a list or in a database. To use the data form, select any cell in a list or in a database, and then click Form on the Data menu.
Normally, if the "Database" defined name exists in a worksheet, the PivotTable Wizard correctly uses the range of cells referenced by the defined name. However, if the name "Database" was created by the data form, the name cannot be used by the PivotTable Wizard.