Strange characters in Excel Pivot Table drop-down box

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.
Doc4.doc
jack3_99Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

clarkscottCommented:
Try REFRESHING the Pivot tables.

Scott C
0
Jeffrey CoachmanMIS LiasonCommented:
My guess is that Scott's suggestion will resolve your issue

"Corrupted" Access data can cause all sorts of issues, especially when spanning different applications.

So if that does not work, simply link the entire table into Excel and see if you can identify the "odd" entries in both Excel and in Access.

A more aggressive "cleanup/repair" may be needed.
(Compact & Repair, Compile the code, JetComp.exe, Create a new db and import all the objects, ...etc)
Corrupted Access data will not only "Jumble" some data, but it can also delete or add data, or even records...

;-)

JeffCoachman
0
jack3_99Author Commented:
I had already tried refresh; however, the odd entries remained.  

I believe the problem is with Excel.  I deleted the corrupted Access database and used a backup copy (before the corruption); so, this database was never damaged.  

I am hoping that I don't need to set up new pivot tables as I have 20+ in the workbook.

I appreciate any help.  
Thank you.
0
jack3_99Author Commented:
I found the following at another site that was able to fix the problem:

To prevent old items from being retained in an Excel 2007/2010 pivot table, you can change an option setting:
- Right-click a cell in the pivot table
- Click on PivotTable options
- Click on the Data tab
- In the Retain Items section, select None from the drop down list.
- Click OK, then refresh the pivot table.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
jack3_99Author Commented:
This allowed the clearing of the old corrupt items.  I am not sure the reason the Pivot Tables keep the information.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.