I have a spreadsheet which records workplace accidents - I add a new row for
every incident that occurs (the first column of which is the date of the
accident).

To help me analyse the data I use several pivot tables. However, every month
I have to rerun the wizard on each one to pick up the new rows of data. Is
there any way I can get the tables to update automatically (simply
refreshing the data - manually or automatically - doesn't do it)?

I have tried making the initial range size greater i.e. so that it includes
blank rows at the bottom (where future accidents will be recorded), but this
seems to prevent the date data being grouped into years and months, which I
require.

Any suggestions would be much appreciated.

Thanks,

V

Give this a look. It creates a dynamic named range as the pivot table source...

http://www.contextures.com/xlPivot01.html
--
HTH...

Jim Thomlinson


"Victor Delta" wrote:

I have a spreadsheet which records workplace accidents - I add a new row for
every incident that occurs (the first column of which is the date of the
accident).

To help me analyse the data I use several pivot tables. However, every month
I have to rerun the wizard on each one to pick up the new rows of data. Is
there any way I can get the tables to update automatically (simply
refreshing the data - manually or automatically - doesn't do it)?

I have tried making the initial range size greater i.e. so that it includes
blank rows at the bottom (where future accidents will be recorded), but this
seems to prevent the date data being grouped into years and months, which I
require.

Any suggestions would be much appreciated.

Thanks,

V

"Victor Delta" wrote:

I have a spreadsheet which records workplace accidents - I add a new row for
every incident that occurs (the first column of which is the date of the
accident).

To help me analyse the data I use several pivot tables. However, every month
I have to rerun the wizard on each one to pick up the new rows of data. Is
there any way I can get the tables to update automatically (simply
refreshing the data - manually or automatically - doesn't do it)?

I have tried making the initial range size greater i.e. so that it includes
blank rows at the bottom (where future accidents will be recorded), but this
seems to prevent the date data being grouped into years and months, which I
require.

Any suggestions would be much appreciated.

Thanks,

V

Make one Pivot table, in which you define the range as the columns fi A:D.
This will tackle new entry's. It will also show one blanc, which you can shut
off.

After you have made the first pivot table, copy the pivottable to a new
sheet and then set it as you wish.
as long as you keep alle pivittables in the same workbook, refreshing one
table will automaticly refresh the other tables.

Hope trhis helps

frits Algie

"Victor Delta" wrote:

I have a spreadsheet which records workplace accidents - I add a new row for
every incident that occurs (the first column of which is the date of the
accident).

To help me analyse the data I use several pivot tables. However, every month
I have to rerun the wizard on each one to pick up the new rows of data. Is
there any way I can get the tables to update automatically (simply
refreshing the data - manually or automatically - doesn't do it)?

I have tried making the initial range size greater i.e. so that it includes
blank rows at the bottom (where future accidents will be recorded), but this
seems to prevent the date data being grouped into years and months, which I
require.

Any suggestions would be much appreciated.

Thanks,

V

"Frits algie" wrote in message
...
Make one Pivot table, in which you define the range as the columns fi A:D.
This will tackle new entry's. It will also show one blanc, which you can
shut
off.

After you have made the first pivot table, copy the pivottable to a new
sheet and then set it as you wish.
as long as you keep alle pivittables in the same workbook, refreshing one
table will automaticly refresh the other tables.

Hope trhis helps

Jim & Frits

Many thanks for the helpful suggestions. I'll try them out tomorrow!

Regards,

V