Easier Way to Refresh Pivot Table Data

[[email protected]]

I am looking for an easier way to refresh a pivot table (to avoid any
complications with the PivotTable toolbar and to avoid the select/right
click/refresh thing.

Ideally I would be able to add the ! Refresh button directly into the
file, but I don't know if I can do that. I guess it would be similar
to adding a macro button for the refresh function.

Any ideas? Thanks!

[York]

If your Pivot Table is based on external data ...
then you can use the Pivot table's options to update from the data
automatically every n minutes.
(The Pivot table's options are available by doing a right click anywhere on
the table.)
HTH

Mc Fadden


<[email protected]> a écrit dans le message de news:
[email protected]...
>I am looking for an easier way to refresh a pivot table (to avoid any
> complications with the PivotTable toolbar and to avoid the select/right
> click/refresh thing.
>
> Ideally I would be able to add the ! Refresh button directly into the
> file, but I don't know if I can do that. I guess it would be similar
> to adding a macro button for the refresh function.
>
> Any ideas? Thanks!
>

[[email protected]]

The data will have to be cut and pasted, but thanks for the tip - I
forgot that you could right click anywhere on the table to get to
options.