Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro for auto refresh
Is there a macro where I change a cell in one sheet and the pivot table will
auto refresh. If I change the cell B18 in Dashboard sheet, the pivot table in City sheet will refresh automatically. Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro for auto refresh
Right click on Dashboard sheet tab, view code, paste this in:
'===== Private Sub Worksheet_Change(ByVal Target As Range) If Intersect(Target, Range("B18")) Is Nothing Or _ Target.Count 1 Then Exit Sub 'Refreshes all PivotTables in workbook ThisWorkbook.RefreshAll End Sub '====== Note that this requires you the user to change cell B18. The event will not be triggered if B18 contains a formula whose result changes. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Kim" wrote: Is there a macro where I change a cell in one sheet and the pivot table will auto refresh. If I change the cell B18 in Dashboard sheet, the pivot table in City sheet will refresh automatically. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Excel functions formula and auto refresh refresh | Excel Worksheet Functions | |||
How can I auto refresh a column that has an auto filter in place | Excel Discussion (Misc queries) | |||
Running a macro from an auto-refresh | Excel Worksheet Functions | |||
auto refresh | Excel Discussion (Misc queries) | |||
How can I auto-refresh auto-filters when data changes? | Excel Worksheet Functions |