Hi, i've got this persistent problem in my excel file that suddenly started appearing:
got a huge document with several columns and data. Using pivottables to get statistics(median age etc).
The pivottable pick up data from the entire sheet, like this "Aktuellt!$A$1:$AD$999"
however, when i open the files and try to update the tables, the source data references has changed to something else, like "Aktuellt!$A$16:$AD$16" (only one row). So i get an error message saying theres not enough rows to collect data from. I then have to redo all 32343 tables...
Anyone know why the source data reference in the pivottable changes? Could it be cos some users(shared document) keeps deleting rows?
thanks!
got a huge document with several columns and data. Using pivottables to get statistics(median age etc).
The pivottable pick up data from the entire sheet, like this "Aktuellt!$A$1:$AD$999"
however, when i open the files and try to update the tables, the source data references has changed to something else, like "Aktuellt!$A$16:$AD$16" (only one row). So i get an error message saying theres not enough rows to collect data from. I then have to redo all 32343 tables...
Anyone know why the source data reference in the pivottable changes? Could it be cos some users(shared document) keeps deleting rows?
thanks!