I
Ian
Hoping someone is an expert with data links. I store my
data in access and link it to excel so I can do pivot
tables/charts. I've run into two major problems. a) if
I change the location of my access file (move it to
another directory) I loose my link to the pivot table and
can't figure out how to update it. Also I create
multiple pivot tables from the same data source (I select
everything in my query and just drop in what I need).
But if I just copy and past the pivot table whenever I
change my groupings it carries thru to all the copies.
What's the best way to create multiple independent pivot
tables based on the same source data without recreating
the link for each.
NB: To create my link I choose Data>>Import External DataThis may be why I'm limited? Should I use an OLAP cube
or something?
Any help is appreciated.
Thanks Ian.
data in access and link it to excel so I can do pivot
tables/charts. I've run into two major problems. a) if
I change the location of my access file (move it to
another directory) I loose my link to the pivot table and
can't figure out how to update it. Also I create
multiple pivot tables from the same data source (I select
everything in my query and just drop in what I need).
But if I just copy and past the pivot table whenever I
change my groupings it carries thru to all the copies.
What's the best way to create multiple independent pivot
tables based on the same source data without recreating
the link for each.
NB: To create my link I choose Data>>Import External DataThis may be why I'm limited? Should I use an OLAP cube
or something?
Any help is appreciated.
Thanks Ian.