Easier Way to Refresh Pivot Table Data

  • Thread starter Thread starter TKrepitch
  • Start date Start date
T

TKrepitch

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!
 
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
 
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. :)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table report invalid 0
Pivot Table Help! 1
Refresh CubeFields for existing Pivot Table on OLAP cube 1
Automatically update pivot table when switching to sheet that thepivot table is in 4
Pivot Table Source file 2
"Pivot Table" option in Add / Remove buttons for Pivot Table Toolbar 1
Refresh Pivot Table 2
How to base a pivot table on another pivot table? 3

Back
Top