Hello, recently the data source on the spreadsheet keeps changing out of the blue and not sure what is triggering it. The data source used can be up to 2800 rows, but on the most recent spreadsheet the data source used was only about 140 rows and then automatically reduced to 70 without having pressed or changed anything. The two of us who are sharing those spreadsheets usually only add data to it at the bottom of where the last entry was and refresh the pivot table, so not touching Change Data Source at all.
Haven't found out what's causing this change every time?
Haven't found out what's causing this change every time?