Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Number format in pivottables
0 views
Skip to first unread message
Vital Kerckhofs
Dec 9, 2003, 5:49:47 AM12/9/03
to
We work a lot with pivottables to organise/analyse
data imported from other sources.
Whenever we want to change a datafield, you need not only
to give a relevant name but always each time format the
field of the pivot in the menu "field settings" under the
button "number".
data imported from other sources.
Whenever we want to change a datafield, you need not only
to give a relevant name but always each time format the
field of the pivot in the menu "field settings" under the
button "number".
Is there no way to predefine this for all pivot/fields?
This would save us a lot of time.
Thanks in advance
john philippen
Dec 9, 2003, 9:57:41 AM12/9/03
to
try this
Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable)
End Sub
this is a event on a sheet like sheet1
good luck
--
John Philippen
snozuf222 zonder dit@ ditweghalen hotmail.com
"Vital Kerckhofs" <vker...@tycoelectronics.com> schreef in bericht
news:0a2b01c3be42$299845b0$a501...@phx.gbl...
0 new messages