K
Kay
We have some very complex pivot tables in Excel that unfortunately are not
very stable or flexible when you make changes. The data list is used to
generate multiple pivot tables in the same workbook but the data and the
number of records can change frequently. One time we might have 18000
records and the next time we might have 2500 records. So far it seems that
everytime we have to change the data we have to reset the data source range
for each pivot table. I believe each pivot table was copied via Edit, Move
or Copy, rather than being generated as anew pivot table or based on another.
The data is downloaded from the web and must be edited to eliminate spaces
at the beginning in some fields for all of the records as well as some other
odd symbols. This seems to create a problem with sorting. One field is
based on rages of 0, 1-4, 5-10,11,12,13,14 etc. ANy time you make a change
to the data, the sorting gets messed up and the data seems to become visually
messed up in other ways I can't explain.
If you can point me in the direction of sources or other software that could
generate the pivot tables in a more stable fashio, I would apreciate it.
very stable or flexible when you make changes. The data list is used to
generate multiple pivot tables in the same workbook but the data and the
number of records can change frequently. One time we might have 18000
records and the next time we might have 2500 records. So far it seems that
everytime we have to change the data we have to reset the data source range
for each pivot table. I believe each pivot table was copied via Edit, Move
or Copy, rather than being generated as anew pivot table or based on another.
The data is downloaded from the web and must be edited to eliminate spaces
at the beginning in some fields for all of the records as well as some other
odd symbols. This seems to create a problem with sorting. One field is
based on rages of 0, 1-4, 5-10,11,12,13,14 etc. ANy time you make a change
to the data, the sorting gets messed up and the data seems to become visually
messed up in other ways I can't explain.
If you can point me in the direction of sources or other software that could
generate the pivot tables in a more stable fashio, I would apreciate it.