Hello,
I'm looking at joining data from many workbook tabs into one pivot table... (I've gotten as far as combining (UNION) the data using ranges in MSQuery) to complete the task is it better to use MSQuery or an OLAP cube?
(I'm leaning toward the cube, but I have never used one.)
And when I create other pivot tables, after the table is created I am able to delete the source data tab (in order to make my workbook file size smaller) with teh pivot table still retaining all data, will I still be able to do that using MSQuery or a cube?
(Excel 2003)
Thanks
I'm looking at joining data from many workbook tabs into one pivot table... (I've gotten as far as combining (UNION) the data using ranges in MSQuery) to complete the task is it better to use MSQuery or an OLAP cube?
(I'm leaning toward the cube, but I have never used one.)
And when I create other pivot tables, after the table is created I am able to delete the source data tab (in order to make my workbook file size smaller) with teh pivot table still retaining all data, will I still be able to do that using MSQuery or a cube?
(Excel 2003)
Thanks
