"Cannot Open Pivot Table Source..." Converting Crosstab

CAUSE

This error message appears when you convert a crosstab table that was created from a database that is not contained in a Microsoft Excel worksheet file format (such as dBASE, Lotus 1-2-3, QuattroPro/DOS) and the file that contains the data is not open. This behavior is by design in Microsoft Excel. You cannot convert a crosstab table to a pivot table unless the file that contains the supporting data is either open, or is in the Microsoft Excel worksheet file format.

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.