Pivot Tables

Hi Kay,

Thank you for the forum question.

You can refresh all PivotTables in the workbook if you press Ctrl Alt F5 or if you click on the down arrow under Refresh on the Option tab in the Data group.

Or you can write a macro:

Sub RefreshAllPivotTables()

ThisWorkbook.RefreshAll

End Sub

and then assign it to a button.



Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector