View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Shailesh Shah Shailesh Shah is offline
external usenet poster
 
Posts: 17
Default insert a coloumn in pivot table


It is Not Possible.

Workaround is that you use 2 pivotables side by side from the same pivotcache.
Keep requried columns between this 2 pivottables.
Hide neccessary columns from both the pivottables.

Regards,

Shailesh Shah
http://in.geocities.com/shahshaileshs/
(Excel Add-ins Page)


"ni****a" wrote:

How to insert a coloumn in between two existing coloumn in pivot table