re-using pivot data connection for multiple pivot tables/charts
Posted on 2011-03-15
Someone mentioned to me that if you copy a chart that gets it's data from a connection, the copied chart will not have to read the data again.
Is that true and:
Isn't that the same as just re-using a connection?
Does the same hold true for pivot tables?
I'm using excel 2007, but, others in our group only have 2003, so, I must save as 2003 often.