In Calc is ther a refresh all pivot tables command

I have a file with a number of pivot tables. Having updated some data and calculated the file the pivot table need to be refreshed. I can only see a refresh option when in each pivot table. In excel there is a refresh all command that will do them all at once?

In Calc, look in the Data menu drop down. Data/Pivot Table/Refresh
There are a couple of other entries there as well.

you for the response, Unfortunately this does not solve my issue. Looking at the menu you suggest the refresh option is greyed out unless you are in a pivot table. I want to be able to change the data on say sheet 1 and update all the pivots that will be impacted by the data changed without having to go to each of them and then choosing refresh
You say there are a couple of other option on the sub-menu but I only see the single refresh option
Thanks for your help