Excel Tips: Refresh Pivot Table When Source Data Changes - Tutorial
ピボットテーブル: ソースデータの変更時に自動的に更新
Advanced Pivot Table Techniques (to achieve more in Excel)
Properly Handle Date Grouping and Missing Dates in Excel Pivot Tables (show all dates)