Are you trying to preserve the formatting?
http://contextures.com/xlfaqPivot.html#FormatLost

HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Lisa" wrote:

I use a lot of pivot tables. Is there a way to set the layout default so
that every time I insert a pivot table that is opens with a particular
layout. I hate having to change these features in every pivot table