Prev: Pivot table formatting removed/lost/reverted upon refresh
Next: How do I include a date column in the Axis in Excel?
From: JimHawkins on 15 May 2010 01:01
This nuisance is unacceptable!!

"teylyn" wrote:

>
> Hi, this is a well-known nuisance. One workaround is to record a macro
> while you do the formatting and then run the macro after you refresh the
> pivot data.
>
> regards, teylyn
>
>
>
Kevin;674443 Wrote:
> >
> I have a data source that I use to create various pivots and the I use
> thos
> > pivots to create graphs. I replace the detail for the pivots each month
> and
> > refreash each pivot which updates the graphs. The problem is the
> column and
> > data values lose their formatting when I refreash the pivots. Is there
> a way
> > to make the formatting of the graph stay?
>
>
> --
> teylyn
>
> Teylyn -- 'teylyn.posterous.com' (http://teylyn.posterous.com)
> ------------------------------------------------------------------------
> teylyn's Profile: 983
> View this thread: http://www.thecodecage.com/forumz/showthread.php?t=188416
>
> http://www.thecodecage.com/forumz/chat.php
>
> .
>
 | 
Pages: 1
Prev: Pivot table formatting removed/lost/reverted upon refresh
Next: How do I include a date column in the Axis in Excel?