software

I have multiple workbooks with financial data. For this purpose I would
like to plot trends across multiple reporting periods. Ideally I would
like to be able to do this by accessing data in those spreadsheets
without doing cut/paste and creating a whole new pivot table.
The question is: Can this be done in Excel. And if not are there other
commercially available plug-ins to help with this?

Thank you!--
Almi
------------------------------------------------------------------------
Almi's Profile: www.excelforum.com/member.php...oamp;userid=34376
View this thread: www.excelforum.com/showthread...hreadid=541552Almi,

It is possible to combine data from different workbooks using MS Query and
use that query as a basis for a pivot table.

Check out this page on Debra's Dalgleish's site:

www.contextures.com/xlPivot08.html

At the bottom of the page will be a link to a sample file describing how to
do this.

HTH

quot;Almiquot; wrote:

gt;
gt; I have multiple workbooks with financial data. For this purpose I would
gt; like to plot trends across multiple reporting periods. Ideally I would
gt; like to be able to do this by accessing data in those spreadsheets
gt; without doing cut/paste and creating a whole new pivot table.
gt; The question is: Can this be done in Excel. And if not are there other
gt; commercially available plug-ins to help with this?
gt;
gt; Thank you!
gt;
gt;
gt; --
gt; Almi
gt; ------------------------------------------------------------------------
gt; Almi's Profile: www.excelforum.com/member.php...oamp;userid=34376
gt; View this thread: www.excelforum.com/showthread...hreadid=541552
gt;
gt;