Update Pivot Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Thanks
 
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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding to an existing Pivot Table 7
about pivot table 1
Pivot Table update 8
Pivot Table Update 3
Referencing a pivot tables Grand Totals Column 1
Pivot table 1
Pivot tables - memory issues - please help 2
Pivot Table - Changes 5

Back
Top