gravanoc
Active Member
- Joined
- Oct 20, 2015
- Messages
- 351
- Office Version
- 365
- Platform
- Windows
- Mobile
I have 3 pivot tables sharing a data source, a .CSV that I created using a data generator. At some point the fields list shows potential options that aren't in the source. Perhaps they have something to do with the pivot table copies? The fields are _1, _2, _3. Also, there is a Column1. There are no hidden columns or columns by that name. I have tried to fix the Column1 field by deleting the empty columns to the right of the data on the CSV, then refreshing the tables, but it is stubborn. Any ideas about how to get rid of any of these fields?
Data Source CSV
Data Source CSV