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?