Pivot table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

go4cdt - 22 Mar 2006 18:24 GMT

Hi;
I have very large datas in column A & B. To get what I need, I create
PivotTable. But I have to do that manually each time the datas in bot
columns changed (on a daily basis).
Is there anyway that I create the PivotTable once, and the datas i
this pivot table will be updated automatically each time the datas i
column A & B changed.
Can I setup a macro to run the pivot table?
I would appreciate for any help.

go4cd

Reply to this Message

Carim - 22 Mar 2006 18:49 GMT

Hi,

There are two questions in your post :
1. The input data ...
the solution is to Insert Name Define a dynamic range ... so you will
not have to worry about the input data
2. The PivotTable refresh ...
pivottable.refresh can be written in an event macro, ideally your
working sheet ... worksheet calculate event ... all refresh will be
automatic ...

HTH
Carim

Reply to this Message

go4cdt - 23 Mar 2006 19:49 GMT

My datas in column A are changed daily and are not constant in value so
I can't really use the Insert Name Define solution.
The pivot table refresh solution seems to fit my needs better, but I
have no idea of how and what to do with that.
More help please

Thanks

Signature

go4cdt

Reply to this Message

steven1001 - 24 Mar 2006 02:51 GMT

You dont say where the data comes from or how it gets into your
spreadsheet.

If it is in a database then you can use Pivot Table wizard step 1 of 3
to slect the radio button to get the data from an external data source.
That can directly from a database storing the information or from
another spreadsheet where you have stored the information.

In either case you do not have to redefine the data range .. it will
just get everything that is there that meets any criteria you have
entered in the 'get data' process.

Set the pivot table to refresh automatically when you open the
spreadsheet if you want.

regards..

Signature

steven1001

Reply to this Message