I have asked similar question some 10 days back but could not locate it now.
Pl Excuse. I also forgot to click the 'notify me' box below.

I want to give name to the Pivot Table Report just like we give names to the
'view' facility. At present I have to save the different format of the report
in separate worksheets thereby increasing the file size. Instead, I would
like to have one data sheet and only one report with a choice of different
names so that I can have same report views from different angles
e.g. Regionwise Productwise Sales, Salesmanwise monthwise Sales, Productwise
Regionwise Sales etc.
I hope I am clear.

Shrikant

--
Shrikant