Pivot source error

D

darinh2005

Is there a way to change the pivot source?

When I tried to refresh a pivot, I get this: "cannot open pivot table
source file" and the file name.

Is there a way to point the pivot to a source file on a different path?

TIA!


Darin
 
D

Debra Dalgleish

Right-click a cell in the pivot table, and choose PivotTable Wizard
Click the Back button
In Step 2, change the source Range
Click Finish
 
Top