Hello,
I have a one data source table and several pivots referring to it. I cannot refresh those, get the error that column names are not valid, even though there are names fo all colums, no hiddeen colums etc. I see that in Pivot table field list for one of colums, heather shows blank (even there is name in source field). In other pivot tables prevouos name for this column is shown (one that is not in source table anymore, such word combination does not exist in this worksbook anymore. Due to this I cannot refresh data in any of pivot tables.
I have not used field names, have tried to redefine source data (not possible due to "name not valid" error). Even the if the column, whose name shows differently on pivot tables, is delated, it still shows in pivot table field list, still with different names for different pivot tables (in that case data range shows that this field is no longer in range).
Please help me to solve this, I have no idea on what to try next and how to proceed.
Thanks in advance
Bookmarks