Update Pivot Table

B

Brandt

Is there a way I can get my pivot tables to automatically update before I print the sheet containing them

Thanks
 
P

Peo Sjoblom

You can use the before print event
You can record a macro when you refresh the tables, then copy and paste that
code

Private Sub Workbook_BeforePrint(Cancel As Boolean)

'your recorded refresh code

End Sub

It goes into ThisWorkbook (right click the excel icon next to the File menu
and select view code


--

Regards,

Peo Sjoblom

Brandt said:
Is there a way I can get my pivot tables to automatically update before I
Click to expand...
print the sheet containing them?
 
Top