Refreshing several pivot charts with one move

L

lay

Right now, i have at least 6 pivot tables in my worksheet, and there will be
more to come. Whenever i want to refresh the data (it's drawing it from an
access database) i'm selecting each chart one by one. I tried selecting them
all and click the refresh button, but it only refreshes the very first table
i clicked on. Is there a way for me to refresh every table with just one
click?

Thanks in advance!
 

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

Top