re-using pivot data connection for multiple pivot tables/charts

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.

Who is Participating?
Rory ArchibaldConnect With a Mentor Commented:
Pivot tables in 2007 default to using the same cache if they are based on the same data; in 2003 you specify whether to reuse the same cache or not in the PT wizard.
I don't know what you mean about charts getting data from a connection - charts use ranges or hard coded values.
avoorheisAuthor Commented:
Is there a comparable setting in 2007 for "reuse the same cache" ?
Rory ArchibaldCommented:
They do it automatically in 2007. You have to invoke the Wizard or use code for them not to.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.