Hi all,
I am sure that this question has already been asked but I could not find it, so I am sorry in advance if this is the umpteenth post of the same kind
In my office we just had Excel upgraded from 2003 to 2007 (better late than never!), and now I have a problem with data sources.
Generally, when I create multiple pivot tables referencing to the same data, the first one uses a data sheet as source, while the others use the first pivot table, to save on file size. This was commonplace procedure on XL2003, with the usual Pivot Table Wizard > Back > Back.
Now on 2007, the "Change Data Source" does not seem to have an option for that, it only allows me to use a data sheet and not another table. Or most likely, it's me not knowing where to look...
Can anyone help?
Thanks everyone!
I am sure that this question has already been asked but I could not find it, so I am sorry in advance if this is the umpteenth post of the same kind
In my office we just had Excel upgraded from 2003 to 2007 (better late than never!), and now I have a problem with data sources.
Generally, when I create multiple pivot tables referencing to the same data, the first one uses a data sheet as source, while the others use the first pivot table, to save on file size. This was commonplace procedure on XL2003, with the usual Pivot Table Wizard > Back > Back.
Now on 2007, the "Change Data Source" does not seem to have an option for that, it only allows me to use a data sheet and not another table. Or most likely, it's me not knowing where to look...
Can anyone help?
Thanks everyone!
