<div>
thanks<br />
Is there a comparable setting in 2007 for &quot;reuse the same cache&quot; ?
</div>


thanks
Is there a comparable setting in 2007 for "reuse the same cache" ?

<div>
They do it automatically in 2007. You have to invoke the Wizard or use code for them not to.
</div>


They do it automatically in 2007. You have to invoke the Wizard or use code for them not to.

<div>
<div class="content wysiwyg-content">
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.<br />
Is that true and:<br />
Isn't that the same as just re-using a connection?<br />
Does the same hold true for pivot tables?<br />
<br />
I'm using excel 2007, but, others in our group only have 2003, so, I must save as 2003 often.<br />
<br />
thanks<br />
Alan
</div>
</div>


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.

thanks
Alan

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

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.