K
Kay
Hello everyone...a little advise would be appreciated. We have some very
complex and large pivot tables that use data downloaded as text files from
the web. That in itself is a problem because the data must be"prepared" in
order to work with it in Excel. We have many pivot tables, most of which were
copied by using the Move or Copy function. Originally the problem that was
the most frustrating was changing the data source as it was always
changing...larger or smaller. I created an offset formula to set the data
range and that solved the problem. But, it seems that when people move
fields around in one table it messes up another table. If we change the
groupoing in one table it changes the grouping in other tables.When we
refresh data, it changes the sorting order of a number field that was
originally a text field.
All in all, because these tables are being published, we feel that there are
so many explosive changes that cause us to fix and refix the tables that
maybe we are not using the best tool. Any opinion would be appreciated as
well as suggestions of other software that might be more stable.
complex and large pivot tables that use data downloaded as text files from
the web. That in itself is a problem because the data must be"prepared" in
order to work with it in Excel. We have many pivot tables, most of which were
copied by using the Move or Copy function. Originally the problem that was
the most frustrating was changing the data source as it was always
changing...larger or smaller. I created an offset formula to set the data
range and that solved the problem. But, it seems that when people move
fields around in one table it messes up another table. If we change the
groupoing in one table it changes the grouping in other tables.When we
refresh data, it changes the sorting order of a number field that was
originally a text field.
All in all, because these tables are being published, we feel that there are
so many explosive changes that cause us to fix and refix the tables that
maybe we are not using the best tool. Any opinion would be appreciated as
well as suggestions of other software that might be more stable.