It's not clear to me how you want to use custom views to create an
invoice. Perhaps you could use the GETPIVOTDATA function to extract data
from the pivot table. There are examples in Excel's Help files.

Samad wrote:
I want to get Pivot table data on my invoice, is it possible to set custom
views so that I can get Pivot table results on invoice format, I've tried
views that offer excel but it doesn't offer custom views
please help

Thanks



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html