Hi

Can someone help me?

I have a document that contains a variety of pivot tables run from different spreadsheets. Is there any way you can have a programmed button to press which refreshes all the pivot tables in a wookbook?

Please note that there are a few on different sheets of the wookbook.

It saves me having to refresh all individual ones?

Any help at all would be much appreciated!

Thanx

Lorna