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