Pivot Table Item Translation

  • Thread starter Thread starter Bill Gates
  • Start date Start date
B

Bill Gates

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
 
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
'================================
 
Thanks Debra,

That worked a treat :)

Don't suppose you know how to do the same thing not using a Macro?

Regards
 
Retype all incorrect the captions?

Bill said:
Thanks Debra,

That worked a treat :)

Don't suppose you know how to do the same thing not using a Macro?

Regards


that i
Click to expand...
 
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
 
Back
Top