Pivot table returning spurious character

[mhowen]

I have a pivot table showing a count of items in a library. However, one of the library names (Well Drilling Operations) is shown as a single quote mark ` . If I change the library name in the source table the pivot table shows the correct result, but when I change the source back to the correct value the strange mark re-appears! I have reduced the number of characters in the original name (.. Operation) and increased it (..Operationss). Both are fine in the pivot - it is only the correct name that gets translated. Has anyone else seen this weird behaviour.

 

[RoryA]

If the name was overtyped originally, that will be stored with the pivot field and you'll see the behaviour you describe. You should be able to overtype the spurious character with the original name in the pivot and it will persist after that.

 

[mhowen]

Thanks Rory. That was it. Easy - when you know how!
Martin

 

[RoryA]

It always is.