Pivot Table - Change Data source

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SAC - 30 Jun 2007 17:11 GMT

Can I change to data source to an existing pivot table or do I have to start
over?

I currently use a spreadsheet as the data source. It was made from a MS
Access query and I'd now like to make the query the data source.

How can I do this?

Thanks.

Reply to this Message

Roger Govier - 30 Jun 2007 22:37 GMT

Hi
Ron Coderre has written a nice Addin which allows you to alter data
sources.
It is available at Debra Dalgleish's site
http://www.contextures.com/xlPivotPlay01.html

Signature

Regards

Roger Govier

> Can I change to data source to an existing pivot table or do I have to
> start over?
[quoted text clipped - 5 lines]
>
> Thanks.

Reply to this Message

SAC - 01 Jul 2007 17:47 GMT

Thanks!

> Hi
> Ron Coderre has written a nice Addin which allows you to alter data
[quoted text clipped - 11 lines]
>>
>> Thanks.

Reply to this Message

Mr. K - 30 Jun 2007 23:22 GMT

SAC,
In Excel 2003 and possibly former version you can select the pivot
table you are working, than try create another pivot table, but simply
check the selection back when you can determine the area of data
source and include rows and columns of reference.

In Excel 2007 you you have a command to select the data source
directly.

I hope it could help.

Mr. K

> Can I change to data source to an existing pivot table or do I have to start
> over?
[quoted text clipped - 5 lines]
>
> Thanks.

Reply to this Message

SAC - 01 Jul 2007 17:48 GMT

Thanks!

> SAC,
> In Excel 2003 and possibly former version you can select the pivot
[quoted text clipped - 19 lines]
>>
>> Thanks.

Reply to this Message

Rate this thread: