Thread: Pivot Tables
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Arjan Arjan is offline
external usenet poster
 
Posts: 29
Default Pivot Tables

L.S.

Since I'm using pivot tables daily, I lose a lot of time 'lay-outing' them.
Usually I have only one field in the data area, and two or three in the
column area. Is it possible - instead of doing all manual - to autosort all
columns by the data field (descending) and for the layout of the data to have
no decimals (the number format) and a 1000 separator? Since I can't find an
option to change the default layout, should this be done with a script? If
so, how should this look like?

Thanks! Arjan