Pivot table refreshment

[Acadabra]

Dear all,

I'm new here, using pivot table only since a couple of weeks. I've
tried to find out the answer in the old posting, but without sucess.

I've created a pivot table based on a worksheet of data. Some data
(rows) will be added time to time in this worksheet. The user who will
enter the data has no excel knowledge, therefore I want to create a
macro which will update the pivot table with the new data.
The refresh on open option doesn't take into account the new entries.

Also I've heard that it's possible to create button to run the macro.
How to do it?

Thanks in advance for your help.

Chrystelle

 

[Debra Dalgleish]

If you use a dynamic formula to name a range, then use that as the
source for the pivot table, the new data will be included when the pivot
table is refreshed.

There are some instructions here:
http://www.contextures.com/xlPivot01.html#Dynamic


The following article has instructions for recording a macro, and adding
a button to run it.
http://support.microsoft.com/default.aspx?scid=/support/excel/content/vba101/default.asp