You should consider using a macro to filter the database based on each
user's needs, then copying the visible cells to a new workbook and then
basing a new PT on that subset of data. That will give the functionality
that you require.

Is that something that sounds good? Otherwise, set the pivot table to where
you want it, then save the entire file with a new name, and send the file
(with all the data, and the pivot table) to the user.

Bernie


wrote in message
...
On 5$B7n(B8$BF|(B, $Be8a(B3$B;~(B13$BJ,(B, wrote:
On 5$B7n(B8$BF|(B, $Be8a(B2$B;~(B54$BJ,(B, wrote:

Still show error message 1004 when success to split out on the first
of PivotField
name....(only success save 1 file)
But the format are ok, how the split out file need the drill data?
How can i do? Can I run the Pivot Table's name (Sheet name) instead
of PivotTable1?

I know that why show error 1004, because the second pivotfield name is
no data, so the marco cannot save a file without the name...
Now can i do?

Hi Bernie,

How can get the drill data from split file of Pivot table, because
each person need the detail of records. Thanks!