dynamically add date to column area of pivot table - access 2007 Closed

Question

Hello, 

i created a pivot table in access 2007 the structure looks like this

vessel     zone     total    1-mar-12     5-mar-12     12-mar-12     25-sep-12
boat1       north   5          2                                     3


when user updates the table with a new date say 1-Oct-12, i need to automatically add this to the pivot table column area.

any help would be highly appreciated. 


Configuration: Windows XP / Internet Explorer 8.0

Zohaib R · Answer

Hi smd_excel,

If your question is about Microsoft Access 2007, then the pivot tables in Microsoft Access 2007 are updated dynamically and you don't need to do anything, all you need to do is add an extra record/row of data in the original table and it will be updated automatically in the corresponding Pivot Table. 
However, if you have created the table in Microsoft Excel 2007 then you can check the below mentioned steps:

1.	Click the PivotTable report.
2.	Click the Options tab, in the Data group, click Change Data Source, and then click Change Data Source.
3.	In Select a table or range, include the rows till the end of the sheet or till the point you wish to add more data rows.
4.	Click OK.
5.	Add more data to the original sheet and refresh the pivot report.

Please revert for clarification.

smd_excel · Answer

thanks a ton...worked great.

i'm working on another access project and need help in code...and i need to complete in a weeks time...any help wud be appreciated...i posted the 1st query on the forum...pls help

Dynamically add date to column area of pivot table - access 2007

2 responses

Similar discussions

Subscribe To Our Newsletter!