Pivot Table Item Translation

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
 
D

Debra Dalgleish

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
'================================
 
B

Bill Gates

Thanks Debra,

That worked a treat :)

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

Regards
 
D

Debra Dalgleish

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...
 
B

Bill Gates

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
 
Top