Hi, I have a very bizarre problem. I have a file that is several years old. It houses data for training audits by new staff, and creates reports for the trainers via preset pivot tables (and other formuals/charts/macro to update the filters on the pivot tables). The pivots read a tab called Data, from the same named range (datasource A:AU).
Every new year, we roll over the file for the next year. That means we renamed the file "ABC 2019", delete the 2018 data and the trainers start rolling up with the new 2019 data.
However, this year, when the trainer did that with the first training audit, when the macro refreshed the pivot table, instead of picking up just the 1 new staff name (John Smith), it brought in PART of an staff name who hasn't been with the company for 3 years!?! That name has NOT been in data data to roll up for 3 years. In the pivot filter dropdown, just her first name and first 3 letters of her last name show up. (i.e. Jane Dai)
I deleted the tracker data from the Data tab, then re-copy pasted it over. Same thing. Even those the data tab clearly has John Smith in the NAME field, it shows Jane Dai in the pivot drop down. I added a new staff audit underneath John Smith. The pivot then refreshed and now shows "Jane Dai and Dave Green"??? So then deleted all the data for John Smith, added a space at the end of his name from the trainer audit checklist (where the data comes from). And the Pivot updates with "John Smith ". So I tried to roll up the audit without the space... it shows again as "Jane Dai" in the pivot... why???!!
This is driving me nuts. As I said, we've used this file for YEARS... how is it bringing in a name that hasn't appeared in any datasource for over 3 years? But seems to bring in other names fine... just brings in Jane Dai whenever I roll up John Smith?
Has anyone ever seen something like this before?
Bookmarks