Hello,
I come with an issue the likes of which I haven't seen before. On 12/11, numerous Pivots in workspaces I own all broke. These Pivots house employees as columns, and their respective training hours. The Activity Log showed that all data suddenly went to zero. Then, over the next few seconds, new columns of the same employees (with their original email titles) repopulated with the correct data. As you can see in picture 1, over 100,000 cells changed. In conjunction with the Pivot error (picture 2), we were led to believe that this was due to us exceeding the limitation on how many cells or columns a sheet can hold. However, this does not explain the same issue occurring on the same day in two other Pivots (both of which I do not own but initially created and transferred). These had much fewer cell changes (picture 3), do not reference the same source Report, and exist in separate workspaces.
As research, we left these two other Pivots unchanged. However, we rebuilt the large sheet, separating it into four separate sheets created via four separate Pivots. We then renamed the columns (to Last Name, First Name and not the default email) and relinked all data in those sheets to our Dashboards. This was fine up until a week later when it happened again...
On 12/22, the same issue happened to all 6 Pivots (the 2 unchanged sheets and the 4 newly created sheets). Oddly enough, while each of the latter sheets did the same thing as before (that is, changing all cells to 0, then instantly readding all operators as new columns with the correct data), the two unchanged sheets reverted back to being 100% correct. The data populated in the original columns, leaving all the untouched email columns with 0's. Unfortunately we are unable to see what error was reported by these Pivots because too much time has passed.
We have wracked our brains attempting to solve why this happened, all to no avail. To our knowledge, there are only two things these sheets, which exist in different workspaces, share: The code that populates the data, and me being the original owner of these workspaces (and the Pivot's). We have ruled out the code that populates the data as 1.) no updates were made around this time, and 2.) much of the data attached to operators name's are part of fiscal year archive sheets, which are completely detached from the active sheet that populates via the code.
I do wonder if perhaps something happened with my license after the first Pivot reached 100,000 cells? We are leery of spending hours relinking all the data again, just for this issue to happen once more. We are really out of ideas other than this being a strange bug. Any help would be appreciated, and if there's any more pictures I can provide I'll gladly assist!
Thank You, Brian
