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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table report invalid 0
Pivot Table Help! 1
making an excel table visible for external data on pivot table 1
pivot tables in multiple workbooks using one datasheet? 3
Excel Error while updating an external data source into a pivot table! 0
Pivot Table Source file 2
Automatically update pivot table when switching to sheet that thepivot table is in 4
pivot table loosing decimals (vba) 1

Top