My Excel pivot table is linked to an Access database. The Access database was corrupted and had some strange characters in the records. The strange characters appeared in the drop-down box when filtering the pivot table.
I have cleaned up the Access database; however, the strange characters still appear in the pivot table. Do any experts know how to remove them? Besides cosmetic, they are a nuisance when selecting various records.
Attached is a screen-shot of the filter drop-down box.
Thank you in advance for your help.