This connection cannot be used because it is already used by another PivotTable report created in one of the following ways: ...

This connection cannot be used because it is already used by another PivotTable report created in one of the following ways:• With the Query external data source as you select each report filter field item option in the PivotTable Field Advanced Options dialog box selected• With the Optimize memory check box in the PivotTable and PivotChart Wizard Options dialog box selectedTo change these options, you must use the PivotTable and PivotChart Wizard (with the PivotTable report selected, press ALT+D+P). To add this wizard to the Quick Access Toolbar, click the Microsoft Office Button, click Excel Options, click Customize, and then add the PivotTable and PivotChart Wizard button (For more information, click the Help button on the Excel Options title bar).To create a new connection for this PivotTable report, select a connection file in the Connection files on this computer section below.