Prev: counting identical items in a column and returning the occurrences
Next: Counting Days
From: diogobacon on 26 Mar 2010 16:30

Good afternoon,

I doubt the following staff:

I know that you can create a Pivot Table apart from others in the same
workbook (they share the cache).

But I wonder if it is possible, normally or using VB to create a Pivot
Table starting at one that is in another workbook.

Thank you for your help.

Diogo A. Viana




--
diogobacon
From: Fred Smith on 27 Mar 2010 01:28
I had no problem doing so in Excel 2007.

The procedure was:
-- Open both workbooks
-- In the target workbook, specify Insert>Pivot Table
-- For Select a table or Range, click the Collapse Dialogue button
-- Go to the other workbook and highlight your data table, then click on
Expand Dialogue button
-- Continue normally with the other options

Regards,
Fred

"diogobacon" <diogobacon.5f31931(a)excelbanter.com> wrote in message
news:diogobacon.5f31931(a)excelbanter.com...
>
> Good afternoon,
>
> I doubt the following staff:
>
> I know that you can create a Pivot Table apart from others in the same
> workbook (they share the cache).
>
> But I wonder if it is possible, normally or using VB to create a Pivot
> Table starting at one that is in another workbook.
>
> Thank you for your help.
>
> Diogo A. Viana
>
>
>
>
> --
> diogobacon

From: diogobacon on 30 Mar 2010 09:36

It makes sense and works, but my idea is to use the same cache that is I
would like to preserve the formulas in a pivot table to another.

Thank you,

Diogo A. Viana


'Fred Smith[_4_ Wrote:
> ;940627']I had no problem doing so in Excel 2007.
>
> The procedure was:
> -- Open both workbooks
> -- In the target workbook, specify Insert>Pivot Table
> -- For Select a table or Range, click the Collapse Dialogue button
> -- Go to the other workbook and highlight your data table, then click
> on
> Expand Dialogue button
> -- Continue normally with the other options
>
> Regards,
> Fred
>
> "diogobacon" <diogobacon.5f31931(a)excelbanter.com> wrote in message
> news:diogobacon.5f31931(a)excelbanter.com...-
> >
> > Good afternoon,
> >
> > I doubt the following staff:
> >
> > I know that you can create a Pivot Table apart from others in the
> same
> > workbook (they share the cache).
> >
> > But I wonder if it is possible, normally or using VB to create a
> Pivot
> > Table starting at one that is in another workbook.
> >
> > Thank you for your help.
> >
> > Diogo A. Viana
> >
> >
> >
> >
> > --
> > diogobacon -




--
diogobacon
 | 
Pages: 1
Prev: counting identical items in a column and returning the occurrences
Next: Counting Days