Bill
Thu Jun 03 06:10:15 CDT 2004
I knew I should have put the option on the Tools Menu....
Maybe I should put it in the 2005 release of excel
Bill G
"Debra Dalgleish" <dsd@contexturesXSPAM.com> wrote in message
news:40BF04C8.1010401@contexturesXSPAM.com...
> Retype all incorrect the captions?
>
> Bill Gates wrote:
> > Thanks Debra,
> >
> > That worked a treat :)
> >
> > Don't suppose you know how to do the same thing not using a Macro?
> >
> > Regards
> >
> > "Debra Dalgleish" <dsd@contexturesXSPAM.com> wrote in message
> > news:40BEF9EA.9030003@contexturesXSPAM.com...
> >
> >>You could use a macro to restore the original captions:
> >>
> >>'=============================
> >>Sub ResetCaptions()
> >>'retrieve original field names
> >>'if captions have been typed into pt
> >>On Error Resume Next
> >>Dim pt As PivotTable
> >>Dim pf As PivotField
> >>Dim pi As PivotItem
> >>Set pt = ActiveSheet.PivotTables(1)
> >>For Each pf In pt.VisibleFields
> >> For Each pi In pf.PivotItems
> >> pi.Caption = pi.SourceName
> >> Next pi
> >>Next pf
> >>pt.RefreshTable
> >>End Sub
> >>'================================
> >>
> >>Bill Gates wrote:
> >>
> >>>Hello All,
> >>>
> >>>I am having a little problem with my Pivot Table...
> >>>
> >>>My PT shows custom names in the ROWS section and there spends over the
> >>
> > last
> >
> >>>12 months as the Data
> >>>However I overtyped some of the Customer names just to see what would
> >>
> > happen
> >
> >>>and now I can not get the original names back.
> >>>my data still shows the original names but the PT only shows the ones i
> >>>overtyped (so i have a lot of customer name which follow the 'sdsd',
> >>
> > 'ffee'
> >
> >>>'fred bloggs' pattern)
> >>>
> >>>even when i refresh the names i entered still return.
> >>>
> >>>It would appear that excel is translating the actual name for the one
> >>
> > that i
> >
> >>>entered but i have not been able to find a way of RESETING the
> >>
> > spreadsheet.
> >
> >>>any help on this matter would be greatly appreciated.
> >>>
> >>>Thanks
> >>>
> >>>
> >>
> >>
> >>--
> >>Debra Dalgleish
> >>Excel FAQ, Tips & Book List
> >>
http://www.contextures.com/tiptech.html
> >>
> >
> >
> >
>
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
>
http://www.contextures.com/tiptech.html
>