pivot tables refresh

  1. D

    Refresh PivotTables in ActiveSheet by Selection

    Hi Excel Experts, Can anyone help me to edit this so that it will only refresh on ActiveSheet instead of entire workbook, please? Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable) Dim wsMain As Worksheet Dim ws As Worksheet Dim ptMain As PivotTable Dim pt As PivotTable Dim...
  2. H

    Refresh Excel Pivot Tables at Set Date/Time

    Hi All, I am working on an excel project where I have multiple pivot tables in a report attached to an external source cube of data. The pivot tables in the workbook take about 45-60 minutes (blocking the usage of other excel sheets) to go through a total refresh of the data given the level of...
    • hallcr
    • Thread
    • application.ontime automatic refresh pivot tables pivot tables refresh schedule refresh
    • Replies: 0
    • Forum: Excel Questions

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top