pivot tables

[iain]

I have a spredasheet which contains a huge number of pivot
tables that do not feed off one another. Is there anyway I
can refresh all of the tables in one go without having to
refresh them individually ?

Cheers

Iain