It should be noted, rebuilding one of smaller spreadsheets DID work. There are random threads going back more than a decade, but no one seems to have an actual fix (other than the one above, and others saying to rebuild the spreadsheet). To note, there is a "supposed" fix on some other threads, always the same, but does not work for me:ġ) Right click your pivot table -> Pivot table options -> Data -> Change "Number of items to retain per field"Ģ) Wipe all rows in your data source except for the headersĤ) Save, and close all instances of ExcelĪgain, this "fix" did not work (at least for me).Īny help with this issue would be greatly appreciated. The files are upwards of 20-30MBs each, some with upwards of 400 pivot tables and other references.So not quick to rebuild I hadn't seen this until about a year ago when one spreadsheet suddenly started doing this, then another, and now I have 3 of them. However, my a few of my spreadsheets show the following (note the "2" after DEF): Mass of confidential data that I cannot upload):Ĭonsidering the above table, a pivot should display a summary as follows: A simple example without loading the spreadsheets (they contain a This does NOT pertain to a second header with the same name, but a Field. I am having the same issue, and it is currently happening multiple workbooks (each having their own data sources).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |