Hi!

On the previous versions of Office, when I usually do a Pivot, I always use
the external data source. Now, even if my external data source is another
excel file, I can still select the columns which I want to use on the pivot
to save space. When I do this on Office 2007, it seems that if you use
another excel file as your external datasource, it captures all the columns.
Is there a way that I can select only the columns that I need?

Regards,
Arj

Hi,

I have no problem selecting just the columns I want. Here is what I'm
doing, you tell me what's different with your approach.

I open both Excel files and tile them on screen.
In the file where I want the pivot table I choose Insert, PivotTable
I then click in the other window and select the two columns I want.
When I hit OK the new Pivot Table Field List only shows the two fields I
selected.

I tried it with the source range defined as a table and it still worked.
--
Cheers,
Shane Devenshire


"Arj" wrote:

Hi!

On the previous versions of Office, when I usually do a Pivot, I always use
the external data source. Now, even if my external data source is another
excel file, I can still select the columns which I want to use on the pivot
to save space. When I do this on Office 2007, it seems that if you use
another excel file as your external datasource, it captures all the columns.
Is there a way that I can select only the columns that I need?

Regards,
Arj

Hi Shane,

I don't open the other excel file. It acts like a database. It's like you
are connecting to an access or sql server and then select only the fields
that you want to use. But in this case, it's another excel file.

On the older version of office, you can do this by defining a name to the
sheet and then later on it will act as a database when you use get data on a
pivot table.

Regards,
Argie

"ShaneDevenshire" wrote:

Hi,

I have no problem selecting just the columns I want. Here is what I'm
doing, you tell me what's different with your approach.

I open both Excel files and tile them on screen.
In the file where I want the pivot table I choose Insert, PivotTable
I then click in the other window and select the two columns I want.
When I hit OK the new Pivot Table Field List only shows the two fields I
selected.

I tried it with the source range defined as a table and it still worked.
--
Cheers,
Shane Devenshire


"Arj" wrote:

Hi!

On the previous versions of Office, when I usually do a Pivot, I always use
the external data source. Now, even if my external data source is another
excel file, I can still select the columns which I want to use on the pivot
to save space. When I do this on Office 2007, it seems that if you use
another excel file as your external datasource, it captures all the columns.
Is there a way that I can select only the columns that I need?

Regards,
Arj

Hi Arj,

I don't know if there is an Excel 2007 way to do that but here is one
solution:

Press Alt D, P, and proceed as you did in 2003.

I'm going to say I seem to remember something to the effect that this is the
only way to do this in 2007.

--
cheers,
Shane Devenshire


"Arj" wrote:

Hi Shane,

I don't open the other excel file. It acts like a database. It's like you
are connecting to an access or sql server and then select only the fields
that you want to use. But in this case, it's another excel file.

On the older version of office, you can do this by defining a name to the
sheet and then later on it will act as a database when you use get data on a
pivot table.

Regards,
Argie

"ShaneDevenshire" wrote:

Hi,

I have no problem selecting just the columns I want. Here is what I'm
doing, you tell me what's different with your approach.

I open both Excel files and tile them on screen.
In the file where I want the pivot table I choose Insert, PivotTable
I then click in the other window and select the two columns I want.
When I hit OK the new Pivot Table Field List only shows the two fields I
selected.

I tried it with the source range defined as a table and it still worked.
--
Cheers,
Shane Devenshire


"Arj" wrote:

Hi!

On the previous versions of Office, when I usually do a Pivot, I always use
the external data source. Now, even if my external data source is another
excel file, I can still select the columns which I want to use on the pivot
to save space. When I do this on Office 2007, it seems that if you use
another excel file as your external datasource, it captures all the columns.
Is there a way that I can select only the columns that I need?

Regards,
Arj