Data source for pivot table

H

Holly

I have saved datasource in my personal drive, and pivot table is saved in the
network drive, so everyone could drill down to their own department, I have
refreshed pivot table before I saved it. Then I worked on pivot table for
various analysis.

But the others could n't drill down their dept, they've been able to drill
down before, anyone has clue why the other people couldn't drill down their
dept?
 

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

Excel 2007 pivot table using analysis services cube as data source 0
Pivot table drill down data 2
Pivot Table Missing Filter Tab 1
How do I sort pivot table data by subtotals? 2
Pivot Table - Drill down to source and update 1
Drill down pivot table data via VBA macro 6
Pivot Table with MS Access as DataSource 1
Consolidated Pivot table 1

Top