I am testing out a tool that I have been working on for the past few months, and I have sent it to several people on my floor to test it. It works fine for everyone.

I tried to give a demo to a manager this morning, but on his computer it kept getting errors. The tool is built to set pivot table dropdowns equal to selections made in other drop downs through VBA. The error says "(All) is not an item in that field" (or something along those lines). If I select any of the pivot table filter cells on his computer, there are leading apostrophes in front of every selection, and I think that is what is screwing everything up. This leading apostrophes are not on anyone elses computer when we use the tool. We are all using Excel 2010. The pivot tables are linked to data in an access database.

Any thought?

Thanks!